Is is possible to make the edit button on Handover control the edit function on Bdown also Currently Handover contains: Code: Private Sub btnEditClick() Me.AllowEdits True Me.btnEdit.Caption Editing End Sub Code.
![]() I can set the property to prevent edits, but i need the user to be able to search records. MyCount DCount(UserID, dboNPYACLUser, (dboNPYACLUser.UserID) MyUserId AND ((dboNPYACLUser.CanEdit)False) AND ((dboNPYACLUser.NavBtnID) MyTab )) If MyCount 0 Then Me.AllowEdits False end if. However I have some fields which have to be updated after the form has been closed. I tried putting the following code in the (Before Update Event) of date issued field for instance. If MeDateIssuedNull then MeDateIssued.LockedFalse end if Needless to say this didnt help. I have some fields which cannot be filled in until a later date. Access Form Not Allowing Edits Plus A WholeThese are job records so I have date open, Technician name date completed plus a whole herd of other stuff which has to be filled in as the job progresses. The form to enter new data into the tables is set up with a subform for the second table. I want to allow the user to query for a specific record, have it display in a form that looks exactly like the data entry form, and be able to update the tables from that. ![]() It allows me to update the 2nd table from the query results displayed, but wont allow updates to the main form. So then I tried just doing one form with all the results displayed, no subform, but then it wont allow me to update ANYTHING. Within this form is also a subform that shows additional information about the record from a junction table. I want to create a button that allows me to edit the information on both forms. I have only done the macro that will open the customer form but cant figure out how to do the filter part. When the first form opens the user enters their RespondentID. Once senior has decided which names to comment on I have another form which has the questions to be answered which is opened by clicking a button on the first form. How can I pass a parameter from the first form to the second so that only the records relevant to that senior doctor are displayed The underlying table has 60 senior doctors and 20 junior doctors. The senior doctor is identified by the field RespondentID in the first form. Ive tried putting a WhereClause in the FormOpen command but I still get a dialogue box asking for the parameter RespondentID when the second form is opened. The Bdown subform allows edits without having to click the btnEdit on the main form Handover.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |