I'm trying to create a form that lists:
Main Form:  Family Name (from Family table)
Sub Form:   Meeting information such as date, notes (linked via FamilyID PK
in Family table and FK in Meetings table)

Hi everyone, hope you are well
Can anyone tell me the best way to put "Date From" and "Date To" combo boxes
on a form - I want it to be either a drop down box or calendar so the user
can just choose a date rather than typing it in.

 I use "stations" in road construction.  they are basically feet or meters
from the start of the job, but in the format of   ##+##.## for feet (based on
hundreds) or ##+###.## for meters (based on kilometers).  
Since I use them to do math, can anyone tell me how I can format ...

Using Access 2002, have a combo box on a form and using:
SELECT DISTINCT  tblOutput.Year
FROM tblOutput
WHERE (((tblOutput.Year) Is Not Null))

I have a number of forms with the same subform. ie a form for editing, a
similar one for filtering and one for adding new records. I have done this to
help the user see when they are in filter mode to prevent creation of
superfluous records etc.

Yesterday, I had a user report a problem to me, related to copying and
pasting an existing record into a new record.  I've spent much of today
trying to figure out exactly what happens, and how to prevent this in
future - with little success - and looking for incorrect records in ...

When a form (continuous mode) displays many records I need to be able to read
from VBA code which records are currently selected when a user selects more
than one record via the record selectors. Any ideas would be appreciated.
Many Thanks!

I need to be able to find records by searching the Subject Keyword field
(in a subform).  
I need an option which a non-Access user can manage without too much
instruction.  The instruction will need to be on the form.

My native language isn't English, so I'd like to appologise in advance for
any spelling mistakes I've made.
I created a form wich modifies the appearance of certain controls depending
on the value of one field.

I created a form and I cannot for the life me figure out how to change its
color...
Can anyone give some advice?

I cannot find any help on the syntax for getting the value contained within
the current form and its nested subforms to my OpenRecord 'where' clause.  I
can only get values from the main forms data as in:
DoCmd.OpenReport stDocName, acPreview, ,"CompanyName =

I have a "browse" tabular form which shows critical fields for clients in a
Client table, one line per client .. each line has  a "command button" to
show "More" information .. which brings up a form containing all information
for a client  .. the link between the forms is the ...

I have a minor issue I was hoping to get some help with. On my databases, I
would like to set up the forms so that when a user opens the form it will
automatically open on a new record instead of always opening on record #1 and
then having to click the new record button. I would ...

The tab page is very long and when you open the form, it opens without the
tabs showing.  You must scroll up to see them.  When you go to a new record
it is usually ok.  How do I get it to open at the top with the tabs showing?  
Thanks

I'm sure that I'm just missing a small piece of the puzzle, but I'm not able
to figure out why the following code doesn't loop thru all the data in the
subform.  
Dim rs As DAO.Recordset