Check if data exists in database.

[Stefan van der Hooft]

Hi!

I’ve a form (F_OE_Ideas_FillIn) with a couple fields where users can put
their data in. After they put their data in, I’ve a submit button witch
select all the data from the fields on this specific form and put it in the
database table (T_OE_Ideas).

What I want:
Is a check if the data is already in the database, if so: ask the user
conform this operation and then continue or stop the action.
If the data is currently not in the database, then put the data into the
table (T_OE_Ideas) without confirmation.

Is this possible?

Kind regards, Stefan van der Hooft.

 

[Steve Schapel]

Stefan,

It is not clear what you are doing. What do you mean about "put the
data in the table"... how does that happen? Are the controls on the
form F_OE_Ideas_FillIn bound to the fields in the T_OE_Ideas table? If
so, you could use Conditions on a macro which would run on the Before
Update event of the form.