i have created a stock control system and would like to know how do i desplay
a status dependant on another text box value for instance if the text box the
value sits in is "-1" the other text box must display "please order" i can
get all the values correct wich is only two ...

Hi all. Thanks for your helping me in the recent months, great forum.
Now for problem, I've got a query that lists ID numbers of employees. When
I double click on ID number I need that ID number to be passed on to
another form to look the details of that employee. The employee ID is ...

I have a form that is activated from a switchboard.  The form has a 3
subforms.  When the form is opened for the first time during a session, the
form does not load completely.  Only the subforms and a few of the combo
boxes load, but displays right on top of the switchboard ...

I have a form that I use to search for records.  I have the option to
double click on the record and it will take you to the main form.  When I
get to the main form, the record I clicked on is the only one available.
What I would like is to stay on the current record when I enter ...

I know this might be easy for some, but i can NOT get this to work. here it
goes:
form1 has list of weight#, I use a list box that finds a record on the form
below is what i get, but if I don't find the record, I need to add the

I have a button on a form that runs an update query that adds the current
forms data (mainly text) into a table supplying a note field on a subform.
The first form is a popup and the suform and main form are in the
background. What I am actually doing is copying a standard  ...

I have a form on which there are three Combo Boxes, which I am trying to make
dependent, ie the second Combo Box dependent of the first and the third on
the second.  I have been able to get the second Combo Box to work with the
first by using the following statement as the Row ...

While using formB to add items to a list, I need to requery a combo box
on a subform on formA, but I am having trouble referencing it from
formB.  FormA is open.  I want to requery the combo box without closing
formA.

I have a default date of 01/01/1800 coming up on a form.  I have checked the
source and cannot find where this is coming from.  Any ideas?

I have a field in my table called DTE, it is date field with a short date
format.
on my form i want  the field to only show or allow a input date of month and
year

I am creating a form and would like a timer on it so that when I start
filling out the form the timer will run and when I finish filling out the
form I can click end and the elapsed time will apear on my form

I am developing an HR database and trying to show deductions for each
employee on a subform. The 2 relevant fields are "dedid" and "dedrate".
"dedrate" is a number field but can mean 2 different things.
If dedid = 401, then dedrate is a percentage

how can i show via a query all the platforms by month and year where
additional sample is the highest value?
example: Platform is named Bubba, Month is September, year is 2004 and sort
by additional sample highest value, then next highest value???

I have a combo box bound to column 0 of a table - the ControlSource is a
field named WorKPerformed in my Work table and the RowSource is
SELECT WorkPerformed.[Job Performed] FROM WorkPerformed;
NOTE:  This second WorkPerformed is referring to a table with Job Performed

I created a custom form to supply parameters to a report based upon a
crosstab query.  The form seems to operate fine, except it only will accept a
single set of values, as if it is storing the values it wants to respond
to...!