Form for Last Record?

[dwe73]

I have a fairly elaborate database set up and I have everything working well with 3 tables, 18 forms and 3 queries so far!
What I need now is the syntex neccessary to call up the last record that contains a certain value in a field and then populate other fields to show the record on a form.

[vicsaccess]

so you're looking for the last saved record? check out
https://www.youtube.com/watch?v=d2PI6w_J95Y

[dwe73]

Unfortunately No! I am Looking for the Last Record having a certain Value in a ComboBoxed field! In say the combo box they choose "A" then I want to find the last record with the value "A" and then populate other text boxes on my form with the rest of the record fields. Make any sense?

[ssanfu]

How do you define "the Last Record"?

The last record changes depending on how the records are ordered (sorted). And a table is a "bit bucket". There is no order. So you need to sort the records.

Say there are 15 records that has 4 fields: a PK field (autonumber), a text field that has an "A" as data, an amount field and a dateTime field.
You create a query. If you don't apply a sort order, the "Last Record" *could* change each time you open the query.
Now you sort on the amount field. What is the last record??
If you sort on the date field, you have a different "last record'.
If you sort on the amount field AND the date field, there is a different "last record".


Would you elaborate on what you define the "Last Record" should be?

[dwe73]

I need the Last Record by Date & Time that has a particular Value in a specific field! say the field is a combo box with choices A, B, or C and there will be say 4 records for each choice and I need to call up the last A record, the last B Record, and the last C Record and have them populate a current status form!

[vicsaccess]

sounds like you need a form based on a query with the combo box as the where clause. can you post the DB?

[dwe73]

I put this sample together quickly to demonstrate my needs! There are two right off the bat!

1. The method to use the passwords to login and establish the security level thereby allowing only the managers to open the Manager Tab & only the Supervisors to open the Supervisor Tab, But allowing the Admin to open All Tabs!

2. The ability to establish the queries neccesary to have The Bldg Statuses posted to the frmStatus!

3. I also will need the code to effect a Change Password Form.

ALL HELP will be Deeply Appreciated!

[June7]

DB security is a common topic - search forum. Start with: https://www.accessforums.net/access/...gin-23585.html

Be aware that holding down shift key when opening db will bypass database option settings and Autoexec macro. https://www.accessforums.net/modules...ide-53679.html

I presume frmNavigation is the form with the 'tabs'. I don't like and have never used Navigation form. I find it harder to manage with VBA code. I have done what you describe (programmatically hide tabs based on some criteria) with a normal form and Tab control.


However, this appears unrelated to the original topic of this thread and should be a separate thread. So what form and combobox are involved in the original issue?