fform advancing

C

coconutt

hi, i HAVE A FORM WITH A COmbo box that searches a table and returns the
record, that works great. my issue is when i work with the data and hit enter
it highlites tje serch field(thats okay as well), but it will advance the
information to aNOTHER record. is their any way to control the forms behavior
to either remain the same untill anotherr record is searched for, or clear
out ounce enter has been pushed.

Thanks, I hope I was clear enough

Coconutt
 
S

Shaun Beane

clearing out the contents of the combo box is good practice when being used
for searches. add

me.yourcomboboxnamehere = ""

after the code the wizard has added.
 
C

coconutt

IT will not let me search now, where should i look for the problem. message
is control is bound to unknown field.

cheers\coconutt
 
S

Shaun Beane

it sounds like you put the code i gave you in the data source? you should
put it in the after update event procedure.
 
C

coconutt

where does the code go, i tried macro but those were defined differently

thanks
 
C

coconutt

ok, coffe is working. I put the code in the after update. the field cleared.
i need the actual record searched for cleared. should the code be modified
and entered ithe the primary key's after update?

thanks a bunch
 
Top