Existence of record

[Jerry Anderson]

I have a list box on a search form containing all possible bids in my
department. Ideally, there should be a corresponding detail of each bid on
another form, the detail form. Using the AfterUpdate method of the list box
on the search, it shoulld route to the detail form, with the correct record
loaded. My problem: If there is not a corresponding detail record, the detail
form, when it displays, is blank. How do I check for the existence of a
matching record before displaying the detail form so that I can gracefully
handle the error?

 

[Jeff Boyce]

Jerry

I'm not understanding from your description what your underlying data
structure is...

"How" depends on "what" -- you're describing forms, not data.

In a well-normalized database, you could use an unbound combobox in the
header of a form to select a particular record, then use that combobox's
AfterUpdate event to requery the form (based on a query, based on the
combobox for selection criterion) to load the record.

Regards

Jeff Boyce
Microsoft Office/Access MVP