Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reference field in form from query

Status
Not open for further replies.
pelleg123

pelleg123

IS-IT--Management
Mar 4, 2005
2
US
What is the syntax to reference the value in a textbox in an Access form from a query. I thought this would work...

Between [frmSample]![txtSampleField1] And [frmSample]![txtSampleField2]

... but it doesn't.
 
Sort by date Sort by votes
try
Code: 
[forms]![frmSample]![txtSampleField1] And [forms]![frmSample]![txtSampleField2]

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
210
OzFoxy
OzFoxy
C
  • Question
Query expression negative to a 0
Replies
6
Views
280
dhookom
dhookom
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
530
mikrom
mikrom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
798
strongm
strongm
Swi
  • Question
Select X of each variation of a field 1
Replies
8
Views
372
rashmibala
R

Part and Inventory Search

Sponsor

Back
Top