I have a form who's rowsource is programatically modified based on an
options group.  The query results in a 10 column list where the user is
allowed to choose only one from the list.
Example: the user is presented with an initial list (we will call them)

I'm trying to pass summaries from a lookup in code to a form.  I know that
based on my item numbers what the control name should be on the form but they
are different than the original item number for which I've summarized
transaction activity.  So I'm not trying to create ...

If I want to keep a history (including user names - which I have code for)
that tracks changes done to data, how is this best achieved?

I have an unbound list box that is populated by a query.  Clicking on a
value in the list box moves to the record in the recordset that matches the
value chosen in the list with a specified field:
Private Sub lstBill_List_AfterUpdate()

I am using XP, Office 2003, outlook 2003 etc. I have written code to send
some attachments via email and all works great except for an annoying message
that comes up to basically ask permission to send the email, warning that a
process is trying to send an email etc. Does anyone ...

How do I get a list box to show me a specific set of records when using a
textbox and a combobox together to filter/query the main table?  I can get
the list box to show me the records I'm after using just text boxes or just
comboboxes but not both together and that's what I ...

Can I use a case select for the following form code?  Any help will be most
appreciated, I've tried it but so far have failed.  I prefer to not have the
Debug option show up if a search criteria is entered incorrectly.
Private Sub Form_Timer()

There is a list (lstShow) with many columns, in my form (frmShowlist), that
shows the result from particular query.
And productID is shown on the first column of the list result.
What I'm trying to do is: when user click on that row of list result, it

Table set up:
tblPatient
PatID (PK)
Other variables

Two fields, ConferenceID(key field) and EventNo.  ConferenceID and EventNo
each can contain Dupes, but not the combination of the two.
Good data...
ConfID      EventNo

I have a simple (or so I think :-) Access 2000 query where I am using an
"iif" to specify the "criteria" clause for the field in question... (which
happens to be a date field.) The logic is this... If a field is checked on
the form (frmTest), I want the underlying query to ...

I have a query [qryAgmtsThatAutoRenew] with a field that calculates an
agreement's current expiration date [Expr1] based on its effective date
[EffectiveDate],if the following condition is met: [RenewalID]=1 (the
agreement must auto-renew).

I am using the code below on a form but for some reason when the previous or
First button is clicked while within a new record, it won't respond. ie. no
error, no movement.  The form itself is set at open to disallow
edits/additions/deletions until an appropriate button has been ...

I am baffled about this!  I'm Using Access 2002.  Have a form (frm1), based
on tbl1.  Another form, frm2, is also based on tbl1, and has a subform on it
which is based on tbl2.  tbl2 is in a many-to-one relationship with tbl1.  
The primary key in tbl1 is SamplingID, in tbl2 it is ...

Forgive this multi-post, but I am getting no results in the other forum where
I have posted this... perhaps it should have been here from the beginning.
Is it possible to capture the filter being applied to a subform's
SourceObject through the "Filter By Selection" or "Filter By ...