Search results

When I want to create a new record all the subform fields should be blank but since subform is linked with master form it and when I am selecting vendor from main form combobox it fills the subform fields with existing record.

Yes both are true and set like that only.. my concern is when I want to add new record and when I select existing I'd it is populating rest of subform fields while I want to enter new data for existing I'd.

Hello, I have below situation. I have one form and one subform and on main form i have combo box wherein I can select any existing record and subform populates based on existing data. Now I have to create a new record in order to accomplish that I have created add button on main form and will...

Hello I want to hide the field when user creates a new record with button when we are editing existing record, it should be text field but when we create a new record it should be combo box but problem is that when we hide text box we can still see the space occupied it, do you know better...

Do you mean I can put me.undo instead of cancel =true.. also what if I want to check other criteria before saving the record.

is this same as on error goto errorhanlder docmd.runcommand acsaverecord exit sub errorhanlder: msgbox err.description exit sub

I want to have save button which should fire on before update event of the form ... and check for if user want to save the data or not if not it should goto form's button event docmd.runcommand acsaverecord. My concern is that on form before update event if user selects No then I am putting...

Can anyone please help me on thsi ?

We as technical person can understand it saves automatically when you leave away with record, but end users need save button which is the requirement. and on before update event I want to make sure when they cancel the record should not be saved.

Hello there, I have form in which I have save button which has code as below : docmd.runcommand acsaverecord and form's before update event has code as below to confirm users response whether they want to save changes or not, if they decided not to save changes, on VBNo we are putting code...

If I remove me.undo it is working , dont know what is wrong.

if we dont put any code in form before update event it works but if we want to confirm whether user want to save the record or not. Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo errorhandler If MsgBox("Do you want to save the changes?", vbYesNo) = vbNo Then Me.Undo...

Hello I am creating and saving record and when it asks for confirmation and select no save record, it gives me below error.. search query was not found for any record. If MsgBox("Do you want to save the changes?", vbYesNo) = vbNo Then Me.Undo Cancel = True else ....... end if Thanks

My concern is that when user clicks no to save data from main form and I am doing on before update event of subform to cancel = true, why the save button code does not work.

I am avoiding to test if user cancels it , it should not save the data anyways in the main form and sub form.

Thanks I have below situation I have form and subform when I am moving focus from main form to subform event it asks to save data because we have written before update event of the form and if we cancel it wont get saved it works great . But now I am trying to save data in subform it gets...

Both have different query

So do you mean that is okay to have form before update event to get fired when we move focus from form to subform ?

Hi there, I have form and it has subform inside it and now I have save button, since when we were moving focus from form to subform it was asking to save record as we had form before update event to save confirmation so I removed it and on save button i have written docmd.runcommand...

Same form is being used to create new record and to display existing record. When I create new record it should take I'd which I created and when I open existing record it show me data from record source.