Open form to a last record based on selected item.

[rogle]

I want to be able to select a Name from a combo box and have it open another form to the last record in a table containing that name as one of its fields. The combo box is showing a list of names from a seperate table.

 

[ptpaton]

Ok,

I'm trying to go through a workthrough of your data flow and I'm a little confused. Do you want to disply data in the field [Name] as the name of another field? Or do you want to limit the selections of say a second combo box to only the selected name?

A little more clarification on that would help.

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[rogle]

When I select the name from the list the form will show the last record from the second table who has the same name as selected. Both tables have a field called name. The first just a list of all names the second being data by names. I just want to bring up last record by name selected.

 

[RoyVidar]

Hi!

Records are by default unordered. If you want the "last" record, then you must have some sort of criteria (field) to determine what is last. To assist, we'll also need that.

For instance your saved timestamps for lastedited, added, or some other means of resolving what's the "last" record.

Roy-Vidar