What I believe you are needing to do is write a SELECT statement nested in the Row Source of the properties [Item] field Example: SELECT tblhardware.hardware_name FROM tblhardware WHERE (((tblhardware.hardware_id)=Forms!formname!hardware_ID)); I am sure this is not the exact code but I think you will get the idea.
Hope this works --- In [email protected], "jcombalicer" <[EMAIL PROTECTED]> wrote: > > I have three field in a form namely > 1. item_id > 2. item > 3. hardware_id > > What i wanted to do was when i type an id in hardware_id which is > equal to the hardware_id in my hardware table it will get the value > from my table and pass this value to the item field. > > Hardware Table > 1. hardware_name > 2. hardware_id > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
