Search results

I'm trying to save records with a "save" button. It's code is: DoCmd.GoToRecord , , acNewRec but I get an error and the saving is cancelled. Is there any other way to save a record?? Thanks

Hi, I have a form with data about customers and a subform with their phones (1 to many, customerID is included in phones table). Main form's AllowAdditions property is set to false. In order to add a new customer there's an add button which "onclick" event has this code: Me.AllowAdditions =...

This can't be difficult. How can I refer to a table field in VBA to dinamically change the controlSource of a form control?? I mean changing the source to the same field, but in a different table. For example: Changing Source from Table1.Name to Table2.Name [This message has been edited by...

I'm a newbie access programmer and I have a little problem. It must be easy I have a form where the user must choose one option. Then that form closes and a new one is opened. How can I refer to the value of the first form's control from the second one???? I'm trying this: Select * from...

I have an access 97 database with several tables, and I want to go to one of the tables depending on what the user types in a form. It can't so difficult so, how can I do it?