reopen form (1 Viewer)

[SzymonK]

Hi All I heve two forms : FormNavigation

View attachment 99705
and Form1 , using for inputting data for day and night shift.
I entered the data into the form today, but I closed by accident. After opening the form, access again generated a new record. I would like to open the previous one by pressing button. Here's an example of macro which doesn't work:

Do you have any idea what is wrong?

 

[arnelgp]

you need to go to Design view of your form and Set DataEntry to No, to be able to goto a record.

 

[SzymonK]

Hi arnelgp.
Thanks for reply.
DataEntry is setup for No.

 

[arnelgp]

you can set the Where Condition:

="[ShiftDate] = #" & Format(DMax("ShiftDate", 'yourTableName"), "mm/dd/yyyy") & "#"

 

[SzymonK]

="[ShiftDate] = #" & Format(DMax("ShiftDate", 'yourTableName"), "mm/dd/yyyy") & "#"

It works now, thank you very much.

 

[SzymonK]

="[ShiftDate] = #" & Format(DMax("ShiftDate", 'yourTableName"), "mm/dd/yyyy") & "#"

I'm sorry that I'm bothering you.Is working fine; however, I noticed that I do not necessarily save the last record. The database is in SharePoint, and users have FrontEnd. Many people from different departments will use this form. Is it possible to add something to this macro to show the record based on date (already working) and SiteID?
something like:
="[ShiftDate] = #" & Format(DMax("ShiftDate", 'yourTableName"), "mm/dd/yyyy") & "#"+ SiteID from "yourTableName")
Please, do you know how to solve it?
Thank You

 

[theDBguy]

I'm sorry that I'm bothering you.Is working fine; however, I noticed that I do not necessarily save the last record. The database is in SharePoint, and users have FrontEnd. Many people from different departments will use this form. Is it possible to add something to this macro to show the record based on date (already working) and SiteID?
something like:
="[ShiftDate] = #" & Format(DMax("ShiftDate", 'yourTableName"), "mm/dd/yyyy") & "#"+ SiteID from "yourTableName")
Please, do you know how to solve it?
Thank You

Hi. Sorry for jumping in, @arnelgp might be on break. You could try something like:

="[ShiftDate] = #" & Format(DMax("ShiftDate", 'yourTableName"), "mm/dd/yyyy") & "# AND SiteID=" & Forms!FormName.SiteID

That assumes the SiteID info is available from an open form. Otherwise, we'll need to know where to get it from to fix the code.