<troy_lee [at] comcast.net> wrote in message
news:0ac23150-7f30-48f6-9e09-954c7ed8baad [at] s50g2000hsb.google groups.com...
>I have a form with one user input. It is for a serial number. After
> the user enters the number and clicks a command button, how can I then
> update the other fields on the form?
Build your regular form with the fields that allow you to edit the data...
The, with the form in design mode, add a combo box with the wizard that
allows you to find a record.
When you enter the serial number into the combo box, the rest of the form
will be populated with the record values....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal [at] msn.com
