If my table is in descending, showing last record at the top, why when I
view them through forms it shows the first record and not the last?
Thanks Bob
.........Jenny Vance

I am printing a form that contains several subforms.  In order to have
something visible for people to enter data into, I created a 'blank' subform
that is visible when there is no data in the actual subform.  This blank
subform is place over top of the actual.

I read many posts on the accessmonster site regarding month queries, but
still can't find a best solution for my database.  Here is my situation, I
have Main table, with different department queries.  On the Department field,
Criteria "Department Name."  I also have a field called ...

I am having a lil of a problem here. This is what I have: A expense
report interface, employees enter their expense information press a
button and submit the report to their manager/accounting. I want to
locked all the fields once the employees submit their reports. They

A search didn't reveal the answer so sorry if it's been answered elsewhere. I
could change the On Enter behavior of all the fields on my form I guess but
I'd really like to change the Tools / Options / Keyboard setting to guarantee
users don't jump to a blank record by hitting ...

I have a main form where all geographic information is keyed for a contract.
I then have several subforms connected through Command buttons. I have events
setup on click that auto-populates those fields on the subform with the same
info but my problem is if i go back into a ...

Need Option Group calculated labels
I want to have Option Group labels that are calculated.  The default will
display the current month, the next the previous month, etc.
I find that I can use text boxes to display the calculation but I can not

I have a form, which sources from two different tables via a query. I need to
have a text box display information from certain fields from each table. The
control source only gives me one table to choose from. I can't get on with
the expression builder, having tried the Dlookup ...

Mainform: Patient
Subform1: Intake
     control: [Text22]
     control source="Intake #" & ((Count(*)+1)-(rownum([Form]))) & " of " &

I have a combo box that links to queries to allows for a selection of the day
of week to base a report on.  While it's not a critical issue, I'd love for
the box to show the days in the normal day of week order.  I've created a
table that ranks the days, Sunday - 1 Monday - 2 etc ...

I'm getting: comile error. in query expression 'IIF(Isnumeric(tblstyles.Style
Name),Apploadstring(tblstyles.Style Name),tblstyles.Style Name)'
This happens while using the form wizard to create a PivotTable form. I can
OK through but the style list comes up blank.

I have a combo box that I would like to auto fill based on a list box.  In
the combo box's properties, I have the row source set to
SELECT Circles.Friends FROM Circles WHERE (((Circles.Area) Like
[Forms]![Main Menu]![area_box])) GROUP BY Circles.Friends;

I have a function which is called when a control is clicked and this
function needs to test whether a check box is true or false. The check
box vould be one of several depending on criteria declared when the
form is opened (shift number and process type) so I've declared

Is there a way to open a form filtered when a user types in the first 3
or 4 letters and all records starting with those 3 or 4 letters appear.
I tried using the wizard and typing 3 letters and a wildcard in an
unbound control in a form, but it did not work, it looked for "Pro*"

Could anyone tell me when a form is meant to retrieve records from an
ODBC linked datasource?  When I insert a record into a form linked to
a local table, and then move back one record, and return, the new
record is still there.  If I do this same thing with a form linked to