Help on something else....

[Marks]

Hello...
Was wondering what the best way to do this is.

I have a form which display's numerous records.... somewhere on that form i want some sort of query which will search and output either

"There is a entry with this company name in table 2 would you like to view this record in table 2?" otherwise

"There is no entry for this company in table 2 would you like to create this record in table 2?"

The Trigger would be the company name.... what's the best way to do this?

[NeoPa]

Is this a continuous form or is one record displayed at a time?

[Marks]

Is this a continuous form or is one record displayed at a time?

One Record displayed at a time... basically when viewing a record in the "customers table" there is a section which will try and find a business plan "business plan" table via the Customer Name....

if that makes sense.

[NeoPa]

Assuming you would like to show the related record in a report, you could :

1. Design a report to show the table. This will need some code which we'll cover later.
2. Add a Command Button on your existing form.
3. Add code behind the button to open the report, but filtered to the individual record selected.
4. In the NoData event procedure of the report, add some code to inform the operator that, unfortunately, there is no matching record.

If a report is not really what you want, then a form can be used instead, but forms have no NoData event so the Recordset would need to be checked in the OnLoad event procedure instead. A little more fiddly but can certainly work.