If the entry form has a sub form, would I put that in the beforeinsert on the sub form or the actual form. The entry happens in the sub form.
Results 16 to 19 of 19
Thread: Determine a Label (2000)
-
2 Star Lounger
- Join Date
- Oct 2004
- Location
- Evansville, Indiana, USA
- Posts
- 111
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-11-09 14:31Re: Determine a Label (2000)
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2004-11-09 14:39Re: Determine a Label (2000)
In that case, put it in the Before Insert event of the subform.
-
2 Star Lounger
- Join Date
- Oct 2004
- Location
- Evansville, Indiana, USA
- Posts
- 111
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-11-09 14:46Re: Determine a Label (2000)
I got that to work. I am have some problems creating the query. Where exactly would I put the Select statement when I create the query?
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2004-11-09 14:58Re: Determine a Label (2000)
What I posted was the SQL for a query that can be used to display only records entered by the user selected in frmLogin. To obtain the equivalent in query design view:
Create a query in design view based on your entry table.
Add the fields you need, including the Emp# field.
Enter the following in the Criteria row in the Emp# column:
[Forms]![frmLogin]![cmbEmpName]
Close and save the query.
