Results 1 to 2 of 2
2002-10-25, 17:31 #1
- Join Date
- Sep 2002
- Thanked 0 Times in 0 Posts
Use Current Record for Query (Access 2000 SR2)
I'll describe the problem and there may be two ways to do this. But I'm still interested i using current record for queries.
Cost center Number:
I want to check the box to signify that this record is finished so that the next time I open the form this record will not show up.
Problem. Since the Form is based on multiple queries, I get the error" This recordset cannot be updated:
A Command button that:
Captures the Customer Number, Account Number, Cost center Number, and places it in an update query that runs in the background. The Update query will find all the records matching these 3 criterias and mark them 'done'.
(I'll eventually need this for a "Print Current Record" button to be designed later. I have done this in the past and will research it, but any speedier help will be most appreciated!
2002-10-25, 23:52 #2
- Join Date
- Jun 2002
- Mt Macedon, Victoria, Australia
- Thanked 45 Times in 44 Posts
Re: Use Current Record for Query (Access 2000 SR2)
A query can access data from the current record in a form using the syntax:
So in your case this forms![form-A]![Customer Number]
You can use the expression builder to build expressions like this. (it avoids typing and syntax errors)
have the form open in the back, then in the criteria line of the query, in the relevant field, right click and choose build.
Double Click the + next to forms, then again next to Open forms. Your form will be listed. Click it, and all the controls will be listed in the centre panel. double click the control you want and the expression you want will be displayed at the top. If it is Ok, click OK. If not, edit or delete and start again.Regards