dibblermail
Member
- Local time
- Today, 19:58
- Joined
- Jan 10, 2025
- Messages
- 60
Sorry, me again.
This code was working a few days ago & upon testing it again today it isn't.
Yesterdays code was to fill in text boxes for a new record in this same form.
So I've broken something, or more likely, I need to be more specific to stop the code going off at a tangent.
The code I'm using is this...
When I breakpoint the line & hover over JobID it has the correct job ID in it & this happens regardless of which Job ID I choose.
When it opens the form it's a new form. I have the JOB ID shown in the header of the form whilst I'm creating the database so I can see what it is pulling in. It shows (New) and the form is blank.
If I remove the filter showing at the bottom I'm able to scroll through the records correctly, so I assume it's the filter that's failing.
The form it's opening has a sub form. Is it getting confused as to which part of the form needs the data?
When the blank form opens the curser blinks a few times in a text box on the sub form as if it has focus.
Any thoughts on where I may be going wrong, or how I should hunt down the fix?
EDIT
Also, there's no error message.
This code was working a few days ago & upon testing it again today it isn't.
Yesterdays code was to fill in text boxes for a new record in this same form.
So I've broken something, or more likely, I need to be more specific to stop the code going off at a tangent.
The code I'm using is this...
Code:
DoCmd.OpenForm "form0_AddEditJob", , , "JobID=" & JobID
When I breakpoint the line & hover over JobID it has the correct job ID in it & this happens regardless of which Job ID I choose.
When it opens the form it's a new form. I have the JOB ID shown in the header of the form whilst I'm creating the database so I can see what it is pulling in. It shows (New) and the form is blank.
If I remove the filter showing at the bottom I'm able to scroll through the records correctly, so I assume it's the filter that's failing.
The form it's opening has a sub form. Is it getting confused as to which part of the form needs the data?
When the blank form opens the curser blinks a few times in a text box on the sub form as if it has focus.
Any thoughts on where I may be going wrong, or how I should hunt down the fix?
EDIT
Also, there's no error message.