Write Text Box to A Table

N

neenmarie

I'm using a form as a menu. There is a text box on the form that the user
enters a date into. This date is used in multiple queries during the user's
session. I'd also like to write the date entered to a table. I have an
append query that runs as part of the session, but can't figure out how to
include this text box data in the append. I tried using
[Forms]![PurchasingMenuq].[Text15]. But, it doesn't recognize it. I just
get two boxes in the first record. Pls help. Thank you.
 
G

Graham R Seach

So close!
[Forms]![PurchasingMenu]![Text15]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
N

neenmarie

Thank YOU !!!

Graham R Seach said:
So close!
[Forms]![PurchasingMenu]![Text15]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

neenmarie said:
I'm using a form as a menu. There is a text box on the form that the user
enters a date into. This date is used in multiple queries during the
user's
session. I'd also like to write the date entered to a table. I have an
append query that runs as part of the session, but can't figure out how to
include this text box data in the append. I tried using
[Forms]![PurchasingMenuq].[Text15]. But, it doesn't recognize it. I just
get two boxes in the first record. Pls help. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top