How to run this query

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

Guest

How do you run this query and then display the information on a form.
The SSN and GenderDate come from text boxes on the form me.SSN and
me.GenderDate. So how do I run this and then display the answer?

SELECT Gender.SSN, Gender.GenderDate, Gender.Gender
FROM Gender
WHERE (((Gender.SSN)=[getSSN]) AND ((Gender.GenderDate)=[getGenderDate]));
 
The following KB article may be a good reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304302

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


How do you run this query and then display the information on a form.
The SSN and GenderDate come from text boxes on the form me.SSN and
me.GenderDate. So how do I run this and then display the answer?

SELECT Gender.SSN, Gender.GenderDate, Gender.Gender
FROM Gender
WHERE (((Gender.SSN)=[getSSN]) AND ((Gender.GenderDate)=[getGenderDate]));
 
Back
Top