Sally-
Have you considered putting the combo box in the form header?
If the combo box were bound, I could suggest a solution using an overlay text
box. Also, do you need the combo only when on a new row? Consider
showing/hiding the combo box in the Current event of the form based on the
setting of Me.NewRecord.
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 Sally Vega
Sent: Monday, September 26, 2011 6:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] ComboBox/Continuous Form question
Good morning all,
I'm not new to programming but I'm new to Access/VBA. I'm trying to do
something that should have been easy but can't find a way to do it.
I have a combo box in my continuous form and it is not bound. What the combo
box is doing is an update of the status (from 1 to 7) and then a timestamp of
when the status changed. This part is working.
The problem is that when I change the combo box for one row, it changes all of
the them to the same thing. How can I have it change only to the value in that
row? It needs to remain unbound so that I can do the update.
I would also be happy with just having all of the combo boxes reset themselves
to nothing once the update is done.
Thank you.
This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar