Good Day all,
I have a cbobox for client information on a frminvoices. I would like the
user to have the option to add a new client and address from the form to the
lookup table.

I hope this question has not yet been asked a thousend times, but browsing
the entries by "subforms" filter I haven't found the answer to this question:
I there a simply implementable way to, let's say, make Access recognize the
"On Activate" event in a subform.

I have several forms linked to queries. I had to revise the form, so I
did one form and then saved it under several names. I opened each form,
changed the background color and the title, and the right-clicked in
the upper left hand corner and selected porperties. I then chose the

I have a simple form created by the wizard. It is a straight form, named "frmEnter", based on a single table, named "tblIn". I added
a cbobox, named "cboOwner", with rowsource "SELECT DISTINCT tblIn.Owner FROM tblIn ORDER BY tblIn.Owner;   I also have a textbox on
the form, ...

I have a form with an option box, depending on the option selected I need to
have a different query used for the form, any ideas on how I can do this?
TIA

I have a subform within a form, and the subform pulls in data from one query,
and the other form pulls in data from a different query.
Both forms displays similar fields such as salesman names, products etc. So
when I scroll through the salesman names in the subform, I would like ...

I asked about this in the forms coding NG and didn't receive a response so
I'm going to try here. If I'm asking in the wrong places I'd appreciate
knowing.
Anyway, I have a number of forms which have status bar text assigned to the

My data base contains a data table and a drop down table.  The drop down
table contains 3 fields:  ID number, Town-name, and ZIP.  To populate the
Town field in the data table, the user selects from the drop down list via a
combo box on a form, and the value goes into Town in the ...

Good Day all,
 I am setting up a form for mileage tracking that would include two
checkboxes "One Way" and "Round Trip" The first question that I have is that
I would like the option to only have one check box checked at any one point,

How do I stop a form page with command buttons from opening when accessing a
database?  I want to start at the TABLES tab

I have a query that runs a report (preview) on screen and it works fine. I
have just one problem, right now I have this in the date field "[Date()]"
which runs the query by the default date. Is there a way I can put a
condition in the query to have a CHOICE of either running the ...

I have a form for users to input. I also have a command on the form to
display a report in preview form only. Here is the question, after the user
presses the command the report is display on screen. How can I get to
disappear when the user clicks on the "input form" (NOTE: I ...

Good Day All,
 this is another question based on my milage tracking form. I have a field
on my form called MileageRate, and I would like to have some type of coding
so that if the date of the travel is within "2004" then the milagerate is

I´m new in forms programming. I have 2 tables with n..n relationship.
For that i have 3 tables (these two and one for relationating them).
Table 1: Customers
Table 2: Interests

Private Sub Form_BeforeUpdate(Cancel As Integer)
       Dim varADDRESS As Variant
   If Me.NewRecord Then
       varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS] = '" &