Creating a New Record

[Guest]

I’m using sql2000 w/Access 2002 for the frontend. I have a client work order
form with a subform. The parent form has a combo box that selects a client’s
name. When a client's name is selected the remaining fields on the parent
form display information about the client that is read only. After selecting
a name a RequestedBy field on the subform gets the focus. The user will
complete the remaining fields on the subform of the work order then submit
the work order.

When the form is opened I want a blank form so the user can select a client
then submit a new work order for that client, creating a new record.

The problem I’m having is when the form is opened the parent form displays
the data for the first client in every field except the combo box, it’s
blank. When you select a clients name the information for that client is
correct.

I’ve tried everything I can think of but nothing works. Anyone know what I’m
doing wrong?

Thanks for the help,

Paul

 

[Jeff Boyce]

I'm not sure I can tell from your description if your combo box is a bound
control or not.

One approach to what you've described is to put an unbound combo box in the
header, to allow selection of a client. The Data Entry property of the form
is set to "Yes".

In the AfterUpdate event of that combo box, set the value of a (hidden)
control to the clientID, and set the focus in the first field of the form.

Or have I totally missed your point...?