Form to add record 3

[JavaToPerlNowVB]

I want to create a form to add record to a table only if that record is not in the table, Can I do this in access.
thanks

 

[lupins46]

Make sure you set the id field to be Indexed-No Duplicates in the table design.

 

[JavaToPerlNowVB]

HOw should i connect the form to write data to the table, I have done this using HTML form with perl doing the sql insert but have no idea how to do it in Access
thanks

 

[RoyVidar]

Just ensure the correct indices (single column and/or multicolumn) are set in the table, bind the form to the table (or through a query) - and voila - Access should start throwing uggly messages at you when you try to save a record with dupes ;-) (you can substitute those messages through the form error event, or better, validate yourself in the forms before update event).

Roy-Vidar

 

[PHV]

HOw should i connect the form to write data to the table
Have a look at the RecordSource property of the form object, ie have a BOUND form.
only if that record is not in the table
Have a look at the DLookUp function you can use in the BeforeUpdate event procedure of the control bound to the PrimaryKey field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886