Finding a record based on a field?

[Sol]

On a form I have a combo box for Member ID (not required). The user selects Member ID and if it exists, the corresponding fields are auto- filled based on a query and cann;t be modified here.

Is is possible to add the functionality that if that member does not exist then a new record can be entered here not requiring member id?

Thanks !!!

 

[Fornatian]

You can't add a record without providing all the 'required' detail. I assume Member ID is a primary key or some other required field?

The way you could get round it(I think)is to set the forms Data Entry property to Yes which should allow you to add a record ensuring your form has all the fields available to input all the required data.

This works only if you put an add button on the form whose code is set to change the data entry property.

I would also recommend having a caption to display the forms current mode i.e. 'search' or 'data entry'.

Hope this works.

Ian