Hi Julie,

If you are using a combo or listbox to select the RFQ number you can simply
add the item number field to the Rowsource query of the combo/listbox and
then set the controlsource of the ItemNumber control to refer to the column
in the combo/listbox control. For example: if the item number field is in
the 3rd column of the combo, then your control source for the ItemNumber
control would be:

= [RFQ Number].column(2)

The column property is indexed starting with 0.

Another way is by using an AutoLookup query as the form's recordsource.
Basically this just means that in your query, you include the table that has
the related value that you want to display on your form. To do this you
simply add the table that has the Item numbers to the query, joined on RFQ
Number. Then make sure that the RFQ field is from the *many* side of the
join and then item number field from the one side. Now when sufficient
information is entered into the join fields, the value in the item number
field will be *looked up* for you. You might want to set the locked property
of this field to prevent inadvertant edits from this form since the field
will be editable.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Julie Bedford wrote:
> I would like to setup a form that when a field is on this
> particular form it will auto populate the next field in
> the form. For example: When the RFQ number is entered
> automatically enter the item number. The item number is
> in the same table as the rfq number. Does anyone know how
> this can be done?