Check Query field

B

Barcode

Hello

Could you correct the following code, please?
I need to write the code in a form by Visual Basic.

There is table1 and includes use1, use2, ID,
the Query name is "Table2" and inside it Table1 with use1, use2, ID

I want to calulate use1 and use2 that belong to ID

If I use query so should be the code something like the following, there is
a link from ID to a form that shows with ID as active:

If Query.Table!use1 >= Query.Table!use2 Then
MsBox (use1 &" " & use2)
End If

But if there's another way to calculate use1 and use2 direct from table1
that belongs to ID that is on the form, I think the program will be more
faster. Right ?

Thanks you very much
 

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

Query 2 tables with non-shared fields 4
Help needed passing data from the form to a table. 0
performance issue in form 1
Problem deleting records 1
Query multiple table relationships subquery? 1
Query on two tables with matching null fields 4
IN query not working 3
How to limit insertion of records 3

Top