Update form data while entering?

[optionone]

Hi,

Still rather new to access - was wondering if it is possible to update some fields on a form while data is being entered - specifically to pull client name and surname from an odbc linked table when an account number is put in - to save entering the name by hand and any errors that could occur

Does a form first save data to a temp table or is nothing saved until it is appended to its destination table?

Thanks

 

[missinglinq]

Assuming that the form is bound to the underlying table or a query based on the underlying table (as it should be, in Access) the data is automatically saved when you either leave the record for another record or close the form.

The name and surname should not be saved in the current record, but can be displayed in the form using the DLookUp() function in the AfterUpdate event of the AccountNumber textbox and in the Form_Current event.

Linq ;0)>

 

[optionone]

Assuming that the form is bound to the underlying table or a query based on the underlying table (as it should be, in Access) the data is automatically saved when you either leave the record for another record or close the form.

The name and surname should not be saved in the current record, but can be displayed in the form using the DLookUp() function in the AfterUpdate event of the AccountNumber textbox and in the Form_Current event.

Linq ;0)>

Hi,

The form is indeed bound to the table - if I have understood you correctly though is there no way to show the information whilst in the form but before leaving the record or closing the form?

I'd be concerned that if someone enters the wrong account number by mistake then the wrong client details will be entered with the new form data and it will be on the person entering the data to check the client name thereafter rather than assuming it was right - which i worry wont happen