I have a form with a  calendar that I only want to be visable and have focus
when a date field on the form has the focus. Is there a way to setfocus to
the calendar althou it hasn't been visable, therefore the set previous
control doesn't work?

I have a form in which I enter data that is stored in a table. The control
source of the text box directs the data to a field in the table. If I put a
formula as the control source of a text box, the result shows up in the form
but does not populate in the table. For example; I ...

I have a form that contains calculated data.  If the user decides that the
data is OK he can choose to save the data.  If the user says to save the data
I copy the data to fields that are tied to the table but I can't get the
table to be updated.  What do I need to do to make ...

I have an Access Page that shows related records in a table (ID, Name,
Description). Is it possible to have a dropdown list that changes all the
record information on the page to relate to the Name chosen (in the drop
down)? Right now the only field that changes for me is the ...

I am adding new items to my main switchboard by using switch board manager.
I have 4 items that where prev there. I have now added 5 and 6.  The problem
is that 5 and 6 do not show up on the main switchboard form.
Any ideas.

How do I stop (or control) a record scroll with a wheel on a mouse?
Where does one set that up?
Right now I have a form that is mapped to an index in a combo box. The combo
box is used to change the records. there are other fields listed. if the

I have a form for a client table which takes info from a property table, the
link being property name in both tables.  I would like to set up a combo box
which enters both the property name and a commission value from the property
table into the client table .. i.e. enter both ...

I'am trying to create a field from a field I already have in a table. The
field I have is called Date and has the type dbDate and when you look at the
field in designview it has the property Format put to "short date".
But when I'm using the code below and looks at the new field ...

Is there a way to set up conditional formating using VBA?  I'm trying to
dynamically change the background color of certain fields.  
The alternate method is to use backcolor property, which works fine in form
view, but not at all in datasheet view.

I'm creating a database for my coin collection. I want to enter the data by
country, e.g. all coins for Italy, etc.
My two main tables are:-
tblCountry: pkCountryNo (autonumber); CountryName (text)

Is it possible to create a list box that fills from bottom upwards?
Cheers

On some occations when i open a form in design veiw the subform appears as a
white blank. By highlighting it and opening it there is no problem. However
on other occations it appears as a normal subform in design veiw. Any ideas
why?

How do I update a table with information collected from a form that i
opened via a report?
Open report --> open form --> collect weight from end user --> updat
weight field in table.

I created a form from a table and linked it to two other tables with the
correlating data for two columns using a combo box to scroll down from on the
form.  Everything shows up as the text given in the form which is great but
when opening the linked table by itself, the columns ...

If I add a tabbed control to an existing form the background color is white.
is there any way to change this? I don't see anything on the properties page
for color.