Data Entry & Combo Box

[Guest]

Hi,

I have a form that I want to come up "blank" for data entry purposes.
However, I would also like to be able to have the option of using a combo box
to look up a specific record and display it's particulars on the form. So
far, if I set the form to "data entry" the combo box doesn't work for me. Is
it possible to do this?

Thanks!!
Heather

 

[Van T. Dinh]

Setting DataEntry to Yes / True means that Access will open the Form with an
empty Recordset for input only and you cannot view the existing data in the
Table.

If you want to use the same Form for viewing / editing and adding, set
DataEntry to No.

If you want to open the Form with the new Record as the CurrentRecord for
the Form, you can use the Form_Load Event to do so using the GoToRecord
method (or other methods).

The code can be as simple as:


DoCmd.GoToRecord , , acNewRec