Open form to first query result

[Cheryl R]

I am sure there is a simple answer but I can't find it anywhere...



I have a simple select query that tells me which tool we need to work on next.
I have a button that opens the work order form. I want the button to open the form to the first tagNo on the query.

An important thing to know is that this process will be used by several different technicians, quite possibly at the same time (each user will have a front-end copy on their desktop of course). How do I make the form always open to the next tag in line but never open the same tag number to different technicians?

Do I need to create a recordset for this to happen or is it simply a Where Condition on form open?

Thank you!

[June7]

I don't know what you mean by 'first tagNo' and 'next tag in line'. Is tagNo a unique identifier? You want this identifier to be generated by code? Custom unique identifier is a common topic in forum. Review https://www.accessforums.net/forms/a...ing-23329.html

[Cheryl R]

Sorry, don't mean to be vague...

In my DB, TagNo refers to the tool we will work on. (We are a tool repair shop and one order can have several tools on it.)
The tool gets a TagNo when it is checked in so yes, TagNo is the unique identifier for the tool.

I want to be able to program the button so that when the technician clicks on the "Repair next tool" button, it immediately opens to the next tool to be repaired.
The next tech can click the button at the same time and it gives him the next one and so on...

Hope that makes a little better sense.

[June7]

Still don't understand what 'next tool' would be. Is this a new number that needs to be generated? Or do you want to move to another existing record?

[Cheryl R]

There is currently a query that lists the tools by priority level and oldest date in.
Not a new number, but a sort order for the tools on that queried list.
I simply want it to open the form to the first record in that query.

[June7]

If the form is bound to that query or if it is included in the form's RecordSource by joining, it should open to the first record established by query sort order.

[Missinglinq]

If I understand your process correctly, generally speaking, you're going to need to add a Yes/No Field, call it 'Assigned,' and when a tech calls up the next tool in line, have that Field for that Record set to 'yes.' Then, when calling up the next tool in line, only return the earliest Record where Assigned = No. That way, an repair already assigned won't be included when searching for the next tool to repair.

Linq ;0)>