Input data for update

[Bill Walsh]

I would like to create a query/form that solicits input such as customer
number and then displays that record for update. I can't seem to find out
how to do this. I have tried a text box and on enter use a query select
where the text box = customer number but as soon as I key in the next
customer number the current one gets his number. Customer number is not not
primary key.

 

[Scott McDaniel]

I would like to create a query/form that solicits input such as customer
number and then displays that record for update. I can't seem to find out
how to do this. I have tried a text box and on enter use a query select
where the text box = customer number but as soon as I key in the next
customer number the current one gets his number. Customer number is not not
primary key.

Your textbox is likely bound (i.e. has a ControlSource value). A search box typically would be unbound, since you don't
have any need to capture this data.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Bill Walsh]

I put an unbound combo box in the form header and it worked. Thanks