General information
Category:
Coding, syntax & commands
Hi Ben.
>> When I leave the controlsource empty I have an empty value
but I want the user to have the posibility to search an name
I use for adding an new record a command button
with a click event "append blank" <<
I think we talked about this in another thread. This is your problem:
control source user.name
rowsource user.name
This is your problem. You can't bind the control to the same data source that you are using for its RowSource. If you want to use the combo for navigation. Make it an unbound control. When the user makes a new selection in the combo, it will move the record pointer in its RowSource. When this happens, you can refresh the form's bound controls to display the new information. If I were you, I would use an Add button to add a new person and set the combo's value in the code that does the saving of a person record.
Marcia
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only