Helle everyone,
I have the following situation: I have a form (form1 - more or less an
overview form) from which I want to open another form (form2), which has a
subform (form3).

I open a form, select what I want to filter for and click the 'filter by
selection' button.  Then I change the data in a field on the form and click
on the refresh button.  When I click on one of the print buttons that I
created on the form, I get a run time-error '2486'.  If I ...

Experts,
I need some help with modifying 2 functions "Previous" and "Next"
(navigation buttons for a tab control -- in a form footer)
I thought I had this working properly that now I realize that there is a

Hello Again,
I'm back. If Microsoft charged for the use of this forum they would be rich
off of me alone.
Anyway, here's another scenario I find myself in again.

Hi. Im using Access 2002 on XP.
I have a main form  with a subform and a combo on the subform. The main
form, subform and combo are fed from a queries. The main form has a text
field txtSubject bound to field Subject in tblStudents and the subform has a

I am still having trouble finding a way to isolate one record of the detail
section of a continuos form and change the properties of all of the controls
with in that record.  Because it is a continuos form, I can have a number of
records in the detail section of this form.  Each ...

I’m trying to get a subform to respond to the click of a dropdown on my main
form.  The main from dropdown has the following code:
Private Sub ComboCoName_AfterUpdate()
Me!TxtCoID = Me!ComboCoName.Column(1)

This is driving me nuts.  Here is what I want to do:
I have a control on a form which is a required text field for data entry.  On
the Lost Focus event I placed code to alert the user to enter text if the
field is left null.  Also on this form is a button which executes a macro to

Guys or Girls,
I'm trying to add a new record to current db from a list box. The help
section examples require to much modification and I'm not good at that.
Anyway, I have a listbox named "lstAdmin". All I want to do is add whatever

I have a multi-select list box populated by a query, and a subform linked to
the main form. I want to append each selection from the list box into the
subform.
What VB code do I use to put new record in the subform?

Does anyone know if it's possible to use Leban's calendar as part of the
form? And not a pop-up?
I'd like to have it always showing. I had an ActiveX one that I was using
before, but I'm having a lot of problems with it working on all my user's

I have 4 text boxes set up that you type in a date in short dat
format. The four date data fields in my table are all set to shor
date format. When you press the button to filter I build a strin
that I set Me.Filter equal to, here is a string it built

I am trying to add one year to a given date and have that populated into
another date field, however the code either does not seem to trigger or is
just not right for some reason ---- help.
One the form there is a date field [dtAuditDate]

Does anyone know how to tab to the submit button to make it work?  Right now
I have to hit the enter key to enter data.  But would like to be able to tab
to the button and have it respond like the enter key on the keyboard.
Thanks,

I'm trying to open a Report on an Open event, through a button in a form.
I'm passing a Where Condition, however, the Report seems to ignore it... It
simply shows all the records existing in the table... The record can be
called through 2 diferent buttons, one of them with no filter ...