In Access 2002, I created a form to show the equipment our company has sold.  
The first subform shows the price we paid to get the equipment to our
dealership.  The second subform shows the rental income for the equipment, if
we rented the equipment prior to the sale.   I can get ...

Hi
I built a form based on a query to create an invoice. I have a field in the
invoice called suppliers and when you double click the field it automatically
opens up a form called supplier in the add mode so you can add new suppliers

What I'm trying to do is have the Quarter field automatically update when the
Date Last Bid Sent info is entered. Date Last Bid Sent is in short date
format. Here is the code I've entered:
Private Sub Quarter_AfterUpdate()

Trying to build a data input form based on multiple tables, record source is
set by query builder and correct feilds show up in the field list.  The
controls show up in the design veiw and are manipulatable as usual.  However,
when go to design veiw , nothing, no feilds, no ...

How do I determine which control currently has focus?

I have a form that has records- quotes that are unique by quoteid.  For some
of the records there can be the same job# and tax exempt# as a previous
record.  The tax exempt# is the same for the given job#.  Bottom line if on a
new record a job# from a previous record is selected. ...

I have numerous unbound controls on my form all with calculated values in
the detail section of the form.  For example, I have one text box with
formula "=[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]" as its control source.  This
works fine (as does every other control in the detail ...

to requery a subform, I have the following:
Private Sub Form_Close()
Forms![Rawleads]![Rawleads Date Count].Form.Requery
End Sub

I know this has been answered before, but it's just not working.  I'm trying
to lock a text box so it automatically displays a piece of information from a
table but so nobody can change it.  I've set the property to locked, as well
as put in code on the form's current event to ...

I am trying to pass a date range to a query. I copied the following code,
(from Allenbrowne.com), that was used for a report and edited it for a query.
When I run the code I get this error message:"Wrong number of Arguments or
invalid property assignment".

I have a data entry form with a save button and close form button.
As far as I know close form button will save the record too.
So what's the difference between them, and also X on the maximum, minimum bar?
Thanks

How can I change the value of a text box using the on click event of the
textbox.

I am trying to populate a field from a list in a form.  I have a table set
up with a list of species and i need to be able to pick multiple species from
this list and link them to a wetland.  I have succeeded in using a listbox to
populate a single species for a wetland, but when ...

clkng = does nothing ??
boswell6@sbcglobal.net

I want to check for null values in a text field of a form.  The text field is
blank (i.e. no default value).  I've tried using Is Not NUll as the
validation rule, but it does not work.  My validation text never appears.  
When I try to save the record, I get the message "you can't ...