Discussion on:
View:
Show:
I ran a quick test and it worked fine for me. Describe your problem and maybe we can work through it.
Setting the combo to Null using the form's Current event should work just fine.
Setting the combo to Null using the form's Current event should work just fine.
The command worked for me, but my problem is that when I use the next record button I created for my form, it won't take me to the beginnig of the next form as I am entering new data into the form. The blank form just appears without a cursor in any of my fields. Do you know how I can fix this?
I couldn't get the command to work at first either. It's missing the colon (:) at the end of two of the ErrorHandlerExit command. Add these and it should work.
It worked for me but the information does not save. I can get the combo boxes to cascade and clear when I go to the next form but when I go back to the record the information in the boxes is empty. The rest of the data in the regular fields saves fine.
i usually put the Me![cboname of box]= Null at the end of the combo box afterupdate event.
Sub Combobox_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[record id] = " & Me![Combobox]
Me.Bookmark = Me.RecordsetClone.Bookmark
Me![Combobox] = Null
End Sub
works like a charm, you can even do it if access makes an embedded macro, just add this action.
have always wondered why they don't make that a default part of the code. must confuse a lot of people.
Sub Combobox_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[record id] = " & Me![Combobox]
Me.Bookmark = Me.RecordsetClone.Bookmark
Me![Combobox] = Null
End Sub
works like a charm, you can even do it if access makes an embedded macro, just add this action.
have always wondered why they don't make that a default part of the code. must confuse a lot of people.
oh, wait, i see, you're trying to do that with the same box that holds the name. i usually put a "find" combobox at the top of the form, then when it finds the desired record, the name populates automatically, of course, and the combobox goes blank again. i would rather users only use comboboxes on main fields in the report for data entry, and not ever expect it to take them to another record. if they sometimes do, they might think the record has changed, and start overwriting data, without realizing their mistake. pretty sure that has happened with one of my users...
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
