Possible SetFocus?

[w2wm via AccessMonster.com]

I have a Form and in the form header I have a combo box which looks a
individual record in the detail box. It looks up records by a field called
service number. Within the details on the form I have the user select all
parts needed for service and it looks up data on the customer. The issue I’m
am trying to resolve is when I print the service ticket I put a requery
command in so incoming records populate. Every time the command is pressed
it works correctly, but the service number in the details in now back to the
very first record and the service number in the combo box still has the
ticket I was working on within the box. Is there any way I can requery and
then have my record set back as the ticket I was working on?

 

[Storrboy]

I have a Form and in the form header I have a combo box which looks a
individual record in the detail box. It looks up records by a field called
service number. Within the details on the form I have the user select all
parts needed for service and it looks up data on the customer. The issue I'm
am trying to resolve is when I print the service ticket I put a requery
command in so incoming records populate. Every time the command is pressed
it works correctly, but the service number in the details in now back to the
very first record and the service number in the combo box still has the
ticket I was working on within the box. Is there any way I can requery and
then have my record set back as the ticket I was working on?

Unless you are using a recordsource or filter that specificaly limits the
record you are looking at, Requery will affect all records in that set. I
think Refresh will affect only the current record.