When I use the setvalue the combo box has a bound value with it. So I can't
figure out how to set the value of the second text box to a different column
in the same query. Logically I should be able to, but I can't get it to work.
It gives me an error message that I can't figure out.
The object doesn't contain the automation object 'qryRental_Price'

qryRental_Price is the query I used for both of the values. but I don't
understand the part about the object not containing the automation object.

"Van T. Dinh" wrote:

I am not sure from your description but couldn't you use two SetValue
actions to set the 2 TextBoxes in your Macro?

--
HTH
Van T. Dinh
MVP (Access)




"Anonymous" wrote in message
...
I am building a system to rent videos. When the video bar code is entered
I
want this to populate two fields. One firld with the rental price and the
other field with the sale price in case the customer would like to buy the
video instead. I can run a macro to set the value of 1 box, but I can't
get
it to set the value of the second box because the value is different.
If you can help me I would appreciate it.

thank you.