OK, my database form is based off of a table titled: Show Events, and I want
to pull separate data from a foreign table titled: Show Stores.
One of the data fields I am trying to pull over from the foreign table is
the year that the store joined the organization, which is the ...

I created a new form using a query.  I can see it in design view, but I can't
see it in form view... I get a blank screen.  Any advice as to what might be
causing this would be greatly appreciated it.

My subform updates a table set up to track commodity increases.  Each Vendor
has a commodityID that helps to group vendors that sell like commodities
together.
Currently my main form has three cascading boxes (2 combo, one list):  

Would someone please tell me what is wrong with this line of coding:
CurrentDb.Execute "INSERT INTO tblMovement (InsertDate) " & _
                   "VALUES (" & txtInsertDate & ")"
I am getting a syntex error.  The value of the txtInsertDate is =Now() and I

How do I keep my subform from reverting back to Datasheet view after exiting?
I want the users to see Form view only at all times.
Nicole

Greetings...
What is the best way to insert the UserID into a field in my table.  Users
will have to sign into the database.
Thanks,

I've got a Main form with two subforms, 1 & 2. 1 is based on a query that is
joined to the underlying table that 2 is used to enter data for. I added a
button to Form 2 which deletes the current record from this table. Form 1
requeries On Current and after I've deleted a record and ...

I am trying to design a system wherein based on the the po no. each line
item gets recorded in the database.
If there is a partial shipment for the line 1 shipment than when the item is
being received by the same po no again same line no. it should add up the qty

I have created a database and everything is working fine. I just would like
to access directory contents and displayed then in a form. For example I
have records that I have saved/scan to a particular directory now I would
like to see then on the bottom of the form. Can someone ...

Hi Folks - I have a text box on a report. The underlying query was modified
to display the date in MMM dd, yyyy format. When I run the query, the date
is formatted properly. However, the text box that refers to the query date
field still displays in mm/dd/yyyy format. Note: The ...

How do I make the previous record show up in a new record so it doesn't have
to be typed agian when adding a lot of records?
any help would be greatly appreciated...
Thanks,

Please help! I have 3 entities (Watersheds, Goals, Objectives), all related
many-to-many. These are represented in my Access XP db as tblWatersheds,
tblGoals,
tblObjectives, and tblWatershedsGoalsObjs as the junction table to resolve

I read and read the newsgroups, but I can't seem to wrap my head around
multi-select list boxes.
I have a form based on tblStudentData.  I want to have subForms open up in
ListBox form to select values for student interventions the child/parent

I have a form with a text box.
The text box properties are set to allow verticle scroll bars.
The text box margins (L/R/T/B) are set to .02".  This is to allow reading
the entries easier.

When I try to open a for in an Access database I get a pop-up dialgue box
with the follwoing message:
The expression On Current you entered as the event property setting produced
the follwoing error: A problem occurred while Microsoft Access was