Elizabeth-
Please answer these questions:
1) What is the Row Source of the combo box? Please post the text from SQL view.
2) Is there anything in the Control Source property of the combo box?
3) What is the value in the Bound Column property?
4) What is the code in the AfterUpdate event of the combo box?
5) What version of Access are you using?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
Sent: Thursday, May 19, 2011 6:54 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Combo Box methods- doing this correctly?
Hi everyone,
I have a pretty straight forward data entry form based on a query where the user
uses a combo box to pick a customer (created with the wizard) and then enters
data about that customer.
On it there is a combo box that looks up values in another table and stores the
chosen value in a field. I used the Wizard to create it.
The data entry person is having problems with this field. She says that the
value she chooses "isn't staying" and then when she goes to another control on
the form (a text box)the form switches customers on her.
Any ideas why? The query the form is based on is two tables, a one-to-one
relationship.
Your help is greatly appreciated.
Elizabeth
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar