Requery a table in a combo box query

[Guest]

I'm sort of new to access and vba, and therefore I have a little trouble
finding the answers to some basic problems. Any help will be mostappreciated.

My problem is this- I have a continuous form with a combo box that has a two
table query as a record source, one table is a table containing inventory and
the other table contains the number of items being taken. In the query, I
subtract the amount taken from inventory to show units available.
After I make a choice in the combo box, numerous fields in the other table
are filled in, including the number of items taken.
How can i requery the second table in the combo box query to show the
updated amount taken. using me.combobox.requery doesn't seem to work after
update seems to work.

thank you for your help

 

[strive4peace]

Hi DJ,

until the record is saved, the amounts won't change...

try this:

on the AfterUpdate event of the combo:

'save the record
me.dirty = false

'requery a control(s)
me.controlname.requery


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*