Does anyone know how to solve this problem?
I used the method here:
and it works well while i use the navigation buttons, however when i change using the cbo it doesn't update the other fields on my form.
thanks, maybe I just need to walk away from the project for a day...
razoRjaw
Last Activity: May 4 '10, 06:40 PM
Joined: Sep 25 '09
Location:
-
update form with two navigation methods
-
you sir are a genius.
it was the .boundcolumn that was giving me the trouble. I was unaware that the bound column is refering to the query built on the combobox, I thought it was looking at the table!
just solved 2 days of frustration. -
combo box with two tables?
Ok, I have table A with email address and primary key autonumber. the email addresses are stored here.
next i have table B with other information that i want stored and a form for it.
there is one combo box on the form and i can see the email addresses from tableA, but when it stores them in tableB, the field has the autonumber value not the actual email address which i want pulled from tableA for that specific record.
... -
update: bc I had not set modal to yes, only popupwhen it did not work. now that I've set it to modal it works awesomely!
lesson two: read the post till the end before implementing...Leave a comment:
-
ah sweet that worked! thanks!
ok, now i just need to figure out how to make sure that my switchboard form always shows up.
at least this was a good lesson in versioning my changes more frequently... :)Leave a comment:
-
Modal Form
Hi all, I used the code provided by AJ above and it works, but too well. it doesn't show anything at all on my screen and i don't even see access running in the process list.
Is there a way to force access to not run the code on startup now? like an idiot, i did not save a copy of the project before I implemented the code and my last copy was about 4 hours of work ago...
thanks
No activity results to display
Leave a comment: