Open form to specific record or defualt to new

A

AB

I want the user to be prompted for a bill # as, or before, the form opens.
If the bill # is an existing bill, the form should open to it, but if it is
not, it should open to a new record.

Can someone please help me with this?
 
D

Duane Hookom

I would initiate this from a form that has a combo box of bill numbers. The
command button wizard can be used to open a form where the bill number combo
box is used to filter the "opening" form.
 
A

AB

So how would I go about doing this? When I changed the text box to a combo
box and began to play with it, I got an error about causing problems with the
table.
 
D

Duane Hookom

The combo box would be un-bound (no control source). Then use the command
button wizard to open the form to the proper record.
 
Top