This is where i show my lack of knowledge! I like the idea that Jedraw suggested about select max id and here is my code
DoCmd.RunSQL "Select * from contacts where Rec_id = (Select Max(contact_id) from contacts);"
however the form always halts at this line in the debugger, any...
I've got a form that has the basic information i.e. firstname, surname, email address for creating a new contact. This form works fine and checks that the data endered isn't duplicated in the database. Once this form has been filled the data is squirted into the main contacts form, at which...
I've got 2 forms one with contact details in it and one with company details in it. On the companies form I wish to have a button that creates a new contact from this company and thus opens a new contact record with the company id copied over from the companies form. The tables behind the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.