Write Text Box to A Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
So close!
[Forms]![PurchasingMenu]![Text15]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
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.
 
Back
Top