Select Query code to pick the first record of multiple

  • Thread starter Thread starter Vincent
  • Start date Start date
V

Vincent

Hello,

I would like to know if someone can help with a Select
Query. I am an amateur and I don't know what to do.

I have a relational table with a Form1 and Form2
(subform).

I would like the query to ONLY pick the data in the first
text box (Textbox1) in the Form2 subform.

Can someone please provide the code and instructions on
what to do?

The reason I need this is because the user requires some
lead data on the query and at the same time they want to
get a SUM of all records in the sub form. The minute I
include in the query the Textbox1 the sum will NOT work.

Please assist and thank all those in the past.

Vincent
 
The fact that you mix Select query with a Table and Form fields makes it
difficult to uderstand what exactly you are trying to do.
Select query operates on tables. Yes, it can use form text boxes for
filtering records, but it can not select from form fieds. On the
opposite, form fields show what the query selects.
Could you re-state what is it you want?

Pavel
 
Back
Top