Query on form ?

  • Thread starter Thread starter Rahib
  • Start date Start date
R

Rahib

My question is (I hope I can make myzelf clear, my English
is not very good): can I get a query on a variable (A)
which needs to be filled in via a form, and in this way
checked against another variable (B) in a different preset
table directly after it is filled in ? I was thinking
somewhere in the line of SELECT.. FROM.. WHERE A=B. If not
correct, a warning should be given.
 
hi,
try this
Select..From..Where [Forms]![Form1]![textbox1name] =
[Forms]![Form2]![textbox2name]

put it in the second text boxes after update event.

this might work too
Select..From..Where [Forms]![Form1]![textbox1name] =
me.textbox2name
 
Thanks, I'll try that !
-----Original Message-----
hi,
try this
Select..From..Where [Forms]![Form1]![textbox1name] =
[Forms]![Form2]![textbox2name]

put it in the second text boxes after update event.

this might work too
Select..From..Where [Forms]![Form1]![textbox1name] =
me.textbox2name

-----Original Message-----
My question is (I hope I can make myzelf clear, my English
is not very good): can I get a query on a variable (A)
which needs to be filled in via a form, and in this way
checked against another variable (B) in a different preset
table directly after it is filled in ? I was thinking
somewhere in the line of SELECT.. FROM.. WHERE A=B. If not
correct, a warning should be given.
.
Click to expand...
.
Click to expand...
 
Back
Top