Setting a couple of global values??

[Sue22]

Right so I have a database which is split. I have two values which are universal and only change occasionally so I don't want them in a table against every record in the database. I have currently set them up as globals in a module I want to set it up so I can draw the values in from the backend database rather than having to edit every single copy of the front end each time. anybody any ideas???

[ItsMe]

If you want a value to be available to multiple users you will need to store the value in a table. However, you do not need to duplicate this value in multiple records or in multiple tables. For instance, if you want to communicate to everyone in the office that Elvis has left the building, you could update one record within tblElvis. The best approach for a situation like this would likely be to create a new record every time the status of Elvis changed. A timestamp would indicate which record within tblElvis has the valid status.

[Sue22]

Sounds good but how do I then extract the most recent value using VBA??

[ItsMe]

If there is only one record in a table, no criteria is needed. If you append a new record each time the status of something changes, use criteria in a query to find the most recent change. I usually use a column in a table of data type Date. You can set the default value of the column while in design view of your table. You can add Date() in the Default Value property of your Date column. The most current status will be the record with the latest date in its Date column.

[Sue22]

I've tried to figure out the VBA to get the data out but this is the bit that stumps me????

[ItsMe]

You can use various ways to retrieve data from a table. Many approaches use a Query at some point. Have you tried using a query object? If you want to use VBA, a DMax method might work. Maybe something like
MsgBox = DMax("[MyDateField]", "TableName")

[Sue22]

Brilliant all sorted. Thanks

[ItsMe]

Glad to hear!