Lookup fields and then input to a table

[mxp346]

I have a form that the user enters in an id number. According to that ID number I want the form to lookup the category and description in a table. Then I want to be able to save the ID number and the values that were looked up into a different table. The table that the values are looked up in is tblEvent(eventID, eventDesc, eventCat) and the table I want to put the values into is tblOccurance(Autonumber, OccID, OccDesc, OccCat). I tried setting up a form with the wizard using the tblOccurance fields. This set the source to each of the fields so it would save those fields in the right place, but I can't figure out how to get the values to be looked up. Can someone please help me. Thank you.

Matt

 

[rajeessh]

Use RecordSet to open the query u need and set the values

Else

dlookup the induvidual values in a Function