Auto Populate a text box in a continuous form

[KevinCollins]

I apologize if this is an elementary task but i'm failry new to access. I have a form that lists a series of line items on a purchase order, that I've been able to adequetly display using a continuous form.

I would like to allow the user to add a record at the bottom (which I believe I've accomplished). But I would like to auto populate a description field on the OnExit event of a part number.

Ie. The user types in the part number and tabs over to the description, and the field auto populates from a part number / description table.



Do you accomplish this from a second query or a dlookup method?

Thanks for the help in advance.

[KevinCollins]

I have to add that for better or worse i've programmed the pages using macros, not vba.

[ItsMe]

If you want to include the field "Description" on your form, you will need to first include it in your form's recordset. If your form is bound to a query, be sure to add "Description" to the query. From here, it will be available to add to the form from the "Add Existing Fields" window.

[KevinCollins]

The field is already on the Form. The form is bound to a table called PoLineItems.

I would like to do a lookup on a different Table to pull in the description from a part number that is linked in. Both part number and field are in both tables.

[Bob Fitz]

It sounds to me as though you need to add the part number / description table to the forms query and then add the description field to the query, which is what I think ItsMe was suggesting in post #3

[ItsMe]

On your form, in an unbound textbox place the following... you will need to include your field, control, form names in the code provided.

= DLookup("[FieldDescription]", "tblOtherTable", "[PartNumID] =" _
     & Forms![frmFormName]!PartNumID_on_the_Form)

[ItsMe]

It sounds to me as though you need to add the part number / description table to the forms query and then add the description field to the query, which is what I think ItsMe was suggesting in post #3

I agree....