Deriving field values from other Input field values

[truediamond]

Hi

I have an Input Form used for inputting new records with the control source set directly to the underlying table.

I would like to be able to do the following if possible:

1. Set the default value of one of the fields on the form to the result of a sql select from the table the form is built on as it stands. (eg Want to pre populate the next member number based on the highest member number currently on the table)

2. set a value in another field to the concatenated value of two fields after they have been input by the user.

Is either of these possible? If so ideas and suggestions welcome.

Thanks
Iain