show other field from linked tables or queries

ACCESS NEWB

Registered User.
Local time
Today, 07:13
Joined
Feb 12, 2008
Messages
64
Here is my problem.
trying to create form (lets call it THEFORM)which have 1 of the fields (ITEMID)(autonumber) taken from query.
All data from form should go to one table ( which have ITEMID aswell related to ITEMID in query).
I want to create combobox from ITEMID field in query and instead of seeing number I would like to see other field from that query)
(query have following fields ITEMID,DESCRIPTION)

i was trying setting as row source
select query.itemid,query.description from query;
but thats not it.
hope that you understand me.(ItemID doesnt mean nothing to user, but if he see description he will know what that is)
 
think i got it.What I was doing is taking itemid field in form wizard instead creating combobox in designview and assigning it to query field I want

I go see if that really is solution
Guess I had to articulate problem here in order to find solution
 

Users who are viewing this thread

Back
Top Bottom