I think you need to use the Forms!FormName.ControlName syntax or the Me.Parent.ControlName syntax to get the desired behavior. Tab key behavior when you are using subforms and want to...

I think the issue you are having is related to the OnCurrent event - it gets triggered the first time the form becomes active (after the load and got focus...

A couple of questions to help narrow the scope of the problem: What version of Access are you using, and what format is the database - .mdb or .adp...

The usual method for getting the value of the identity column is to do a query that gives you the maximum value of the identity right after you add the...

How are you triggering the cloning of a record? If it is a button on the main form (presumably bound to the table InvoiceHeader), then you would probably find...

It appears that query should work, and what it would do would be to populate the [Lead] column in the Application table with the value of the matching record in...

The combo box should be a useful way of setting the priority for each record - you can make the priority a numeric column, and hide the actual field while...

To do as you describe really requires the use of VBA - macros are too limited. I presume this is a continuous form that displays multiple records, and you...

The order of records being displayed on a form is determined by the record source for the form - so if your form has a SQL statement as its record...

One of the things about Access, that you will discover if you haven't already, is that the recommended practice is to load the front-end Access file on the workstation, rather...

So are you using the same front-end accdb database and changing the connection string on start? If so, you would need to enumerate all of the form objects to...

We're going to need a few more details (pardon the terrible pun) in order to assist you on this. First of all, if you have a one-to-many relationship between...

You don't indicate what version of SQL Server you are using, but it appears it is a recent one - 2008R2, 2102 and 2014 have an option that you have...

I think there may well be a more general solution that doesn't involve tracking who has what open. I presume you are using ODBC linked tables in your Access...

Regarding the size growth, the first question is whether you have done a compact and repair? It's much more important in .accdb and .mdb files than it is with...