Hello everybody, I have this report. When I double click on any of the
fields in this report I need the form Warehouse to open and to show the
record I've clicked on.... is it possible?
Thanks

Hi Guys, i have a problem adding my inventory.
I have a table call the "product"
Inside the product table i had a field call "UnitsInStock"
I wanted a textbox in the form to allow the user to key in the number of

I have a report that runs from a prompt form that has two controls for date
parameters. The report runs fine on my machine but when another user tries
to run the report they get this error message
"You entered an expression that has an invalid reference to the property

I have a table with a lot of columns. I have two columns i want to prepair to
be used in a tablesheet form. One with sizenumber and another with
productnumber. I have a datasheet form where I want to use the data from
sizenumber and productnumber writen as one ex. "3-345767" ...

Here's my current AfterUpdate on a ComboBox:
Private Sub cboProductFamily_AfterUpdate()
   ' Find the record that matches the control.
   Dim rs As Object

I've got a form that I need to Requery after a certain control is changed.
The control (which is an Option Group) simply has this code behind it:-
Private Sub frmJobType_AfterUpdate()
   Requery

I have several date fields on a form that I want to tab thru.  After
entering the date in the first and tabbing to the second, it seems as though
the whole form looses focus. The blue bar at the top dims until I press
enter and then I can enter the date in the second field.  I ...

In VFP I could include the line..
SET STEP ON
..in my code, and when it fired, the execution of teh code would transfer to
a window where I could step through the code a line at a time OR evaluate the

I have a combo box that I created to link to a table that indicates a list of
reason for cancellation. The combo box is linked to a field in the table that
I have. The same field in the form is not showing a drop-down arrow to choose
from the list in the combo box. How or what do ...

Please help with the syntax error below:
Syntax error (missing operator) in query expression '([RCName] Like '*'
AND [DeptName]Like'*'[DateEntered]Between #1/1/2004# And #9/12/2006#)'
[code] Private Sub Apply_Filter1_Click()

My user (Access '97) in a multiuser front-end back-end linked-tables database
gets a message that a form has been modified and saved since he loaded (and
presumably must have changed) the form. It's a simple form. The only thing I
can see is that each user clicks on the A->Z sort ...

Can anyone explain how l link a combo box so when l select an entry in the
combo list it will lookup and display
another field, what l want to do is when l select a customers name in my
form it will link to their address field

I have a form ("Sales") with several subforms.  One of the subforms,
"Purchaser", is tied to the Sale record by a Purchaser ID in the Sale
record.
When I enter the Purchaser subform, I have some code to add a new

I am struggling with this DSUM function in the following case:
I am trying to get the total amount for the [intImporto] in the reservation
table and display it in a text box using some parameters.  In my form I have
a cboBox to select the apartment on which I want to base my query ...

Hi i would like to have a column chart in ms access 97 from based on 5
texboxes on that form. I know that you can only create charts from a
table or query. Each textboxes have a query that returns a numeric
value. Also how can i make the chart updated everytime you open that