Create a query for a customer then Update

[Bill Walsh]

I want to set up a form/query that requests a customer number and the
displays fields for Updating from the database. I can't seem to fing any
documentation on how to do that. Can someone help.

 

[tina]

you have records stored in a table, which include a customer number,
correct? and you want to edit those records from a form? and you want to be
able to specify a customer number, and have that specific record displayed
in the form so it can be edited, correct?

create a form and bind it to the table. there are a number of ways to go to
a specific record; probably the easiest to set up is to add an unbound
combobox control to the form's Header section, using the wizard, and as you
follow the wizard dialog, make the choices that will allow you to enter a
customer number in the combobox, and *find* the corresponding record in the
form.

if the above is not what you're asking, then i've missed the boat. please
explain what you're trying to do in more detail.

hth

 

[Bill Walsh]

That was most helpful and it worked thanks.

 

[tina]

you're welcome

That was most helpful and it worked thanks.

 

[ramudo]

TINA - I WANTED TO POST THAT I ALSO FOUND YOUR SUGGESTION VERY USEFUL.