extracting data from a table using IF statment

  • Thread starter Thread starter michael goodall
  • Start date Start date
M

michael goodall

i want to extract data from one record on a table using an IF
statement but i do not know how to go about it. the table i want to
extract the data from is not connected to any forms, it just the
result of a counting query. the rough layout of my if statement would
be - IF resultofquery = 1 then open form1 else open form2 . i
appreciate any assistance i will recieve from anyone. many thanks,
michael
 
i want to extract data from one record on a table using an IF
statement but i do not know how to go about it. the table i want to
extract the data from is not connected to any forms, it just the
result of a counting query. the rough layout of my if statement would
be - IF resultofquery = 1 then open form1 else open form2 . i
appreciate any assistance i will recieve from anyone. many thanks,
michael
Click to expand...

Run the query and save the results to an invisible text field (or a
variable in VB if you'd prefer) on whatever form your executing from.


If Me.TextField = 1 Then
DoCmd.OpenForm "form1"
Else
DoCmd.OpenForm "form2"
EndIf
 
You must log in or register to reply here.

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

Similar Threads

DELETE FROM a table WHERE... 1
Extract web-data 3
extraction. 2
Can Linux extract data from .MDB file, and output to text ? 1
Search/Extract Specific Data from all fields in a table 1
How to Populate Data from a table to another 0
Data Mismatch in Excel 2010 4
join tables using a key field 3

Back
Top