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)
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)