hi all
in one form navigation buttons work
in other form not
for example when i press the NEXT RECORD button it shows - you cant go to the specified record
what could be the problem?
thanks
hi all
in one form navigation buttons work
in other form not
for example when i press the NEXT RECORD button it shows - you cant go to the specified record
what could be the problem?
thanks
Last edited by nahum abramovich; 07-26-2020 at 04:22 AM. Reason: specified - Word correction
You don't have another record.or example when i press the NEXT RECORD button it shows - you cant go to the specific record
what could be the problem?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
i have 5 records
Are you at the last record?
Is this a custom button or built in button?
Information provided is too sketchy to provide more than just shots in the dark.
Explain more an you'll get more focused responses.
Do you get the error after modifying or entering a record and then you try to navigate? Happens when trying to go from any record to the next or previous record or just one or the other? Any code behind the form (esp. on Current event)? Already asked - are these custom buttons and if so, show the code for the one(s) that raise the error.
If you're only getting this after editing or adding a record, it can be because the changes are not being saved for some reason. Improper code on custom navigation buttons can cause this.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
When entering a macro on click
Then, after hovering over the text field, he receives the following message:Code:Private Sub Numer2_Click() Dim MyControl As Object Numer2 = Left(Numer2, 3) & "/000" & Mid(Numer2, 4, 4) & "/" & Right(Numer2, 1) End Sub
"The expression On Click you entered as the event property setting produced the following error: Invalid outside procedure."
I will try to explain properly.
from design i created several buttons
save record
next record
previews record
and add new record
now
now the fault appear every time i go out from the form and return to form. look like it dost "remember" the records
Then I guess you have to post the code for each button. However, you didn't answer any of the questions I asked so I don't know if showing the code will help at all. If you cannot answer those questions I can't begin to help you but maybe someone else can.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
HI
on my form when i put records and save i can navigate through them and everything is good As long as I do not leave the form- when i close the form and reopen i cant navigate (there is no records at all).
No code behind the form.
the buttons are built in.
Make sure the form's Data Entry property is set to No
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
thank you it works
thanks to all