I have a form to enable order details to be entered, some products have a
"Standing_Charge", in these cases the "Rental_Period" must also be entered
otherwise the cost is not calculated correctly. How can I alert the user to
enter this value and to ensure that that a value is ...

Instead of using a table value to fill a form field value, I wish to use a
calculated Form field to create a value in a table.

Is it possible (given that I am in a subform) to use VBA to set focus to a
command button on the form (that contains the subform)?
Thank you for your help,
Joy

I've got a form where the user is entering orders.  I'd like it to pull the
price for an item from the master stock item table after the stock item is
entered, but still allow the user to change that price if they'd like and
store it in history (the underlying table for this form ...

I have a db loosely designed on the Northwind db.
I have a Form - 'Orders' that contains the main Form and a subform as a
separate tab. The subform is for 'Special Orders'. The db is to be used
by a friend who opened a home-based dessert business. The Orders form

I have a simple table.
3 Rows.  Printer Name , Location , Model
Based on the dropdown list that will contain the printer names I want to
populate it's location and model in the 2 text boxes supplied.

I have a text field tryong to update another feild on the same form with the
after update event. It is not working. The first field is set as a number
with a default value calcualtion(not to be stored). But that value is passed
to another text field in my form and it is not ...

How do I make subform to use as log notes?
On my Contacts Form, I want to be able to store notes by date. I tried to
use the subform wizard, but whwn I populated the fields with data and saved
the record, the data wouldn't show up when going back to that record - yet it

I have a form based on two joined tables. tblStudentClassInfo and
tblServicesNeeded. I link the tables on two fields, StudentID and CourseID.
tblServicesNeeded has no data.
The form is populated with info from tblStudentClassInfo and has a series of

I have a combo box
But i dont want values in the list to be repeated eventhough the source has
same repeated value
eg source: "papaya", "banana", "apple", "papaya", "apple"

I have a sequence of 5 forms,  I want to pass info from the first form
ending up on the last form gathering another field or 2 as I work my wa
to the last form.  I'm transfering the data from the first form to the
second via hidden text boxes, after the info is passed the ...

I have a form for entry new records but its generates a new ID for each new
record and doe's not let me see or change records I have allready saved.

This forum is wonderfull. I got all my questions anwered, but I got another
one.
I have two linked tables by ID MAIN and ENCOUNTER
I have created a form using MAIN table and used subform function to list

Ok, I have a database that will have deliveries for lumber customers.
There will be an OriginalShipDate and a CurrentShipDate.
So I want the OriginalShipDate to be filled out when the order is
placed, and have it copy to the currentshipdate field.

i have a table that has two forms. one form adds jobs whilst the other
searches the table and displays the job. the search function is required as
we are adding 300 new records daily.
when the person is in the form to add new records I am unable to search the