Search results

and removing the [] from the form name, combined with adding in a cmd to close the table the form updated leaves the system running great!!! Many Many Thanks Peter!

Hmm think you might be right. When I come out of the form (using the above method of 'closing') then i cannot go into any other querys' as it reckons i have a lock on a table... That would suggest to me that neither of DoCmd.Close acForm, "[Add New Membership Details]", acSaveNo or...

1. I was setting default values in some fields, but its all the fields that are retaining their values!! 2. If i close manually it still retains! 3. Pretty sure the form is closed.. well I can't see it hanging about anywhere!! I have manged to workaround it, by setting all the fields to null...

Not Really peter... It was originally when I first constructed it, but I removed any links to a table and replaced them with direct code to add new records when the validation was succesful. Does this make a difference? The reason I am asking is that when I have a form bound to a table, then...

Hi, I have a form that is used to record new information. Behind the form is a VB module that dpes validation on the fields and on succesful validation closes the form down. This all works well, but on re-entering the form, the data from the previous entry remains in the fields. Can...

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...