Defaulting values in a form from combo box.

[springy2003]

Hi, I would like to know if this is possible. I have two tables. The first is tblstore and the other one is tbltype. tbltype fields contain an autonumber (primary key) and a text field. so one record could look like 1, book. There are 4 of these.

The other table has 3 fields. An auto number, a combo box linking with tbltype and the other one is an text field. In a form, I would like to be able to put data in the tblstore, but on the field with the combo box, getting data from tbltype, I would like it to default to one of the 4 option that is availible. Is this possible, since on the form properties, there is a place where you can default it, but I am not sure if it is actually linking to the tbltype. Any solution would be grateful.

Thanks.

 

[Gazonice]

Hi,

I would avoid uisng the lookup field from a table and instead use a new combo on a form that looks up your data, then stores it in a field you specify (what would have been the lookup field in your table).

The wizard could accomplish this for you.

Regards,

Garry