I have a form with 12 subforms that scroll vertically, used in a medical
scheduling application.
When an appointment is added I save the strSQL that pertains to the subform
that initiated the request to a public string.

Hi
I have a form which refers to a qry. I would like to add a command button
that will allow the person to print the details however I would like to print
it as a report.

Does anyone know how to create a default on the combo box after selecting one
item it defaults back to select one? I have been trying to figure this out
for a week now.  I have a combo box with master card, visa, discover, and
select one.  When I choose master card for the first ...

I'm using the Northwind sample database as a starting point to build a simple
ordering/inventory application. (Like a gazillion others have done before me,
lol.)
When I'm in the Orders form and I'm entering a product on one of the subform

I have a continuous form. in the form, i want the it order by Part code then
by deliver date. i try to set one, it run ok. but i put 2, then it doesn't
work. how can i set the order by in the form? thanks!

I have form-1 with a button to open form-2. On form-2 I have a command button
that is disabled. What I want to do is when I’m in form-1 and opening form-2
I want the disabled button in form-2 to be enabled. Is this possible?

I have a field called rqrdate, I want to add 7 days to it and inset it to a
field called  projdate. Could someone please assist?
Thanks!

I have a form based on a parameter query.  I want to be able to only see the
record requested from the parameter query, make any necessary changes, and
then requery the form.  When I get to the last field on the form and press
[Enter], I get a blank record.  I don't want a blank ...

I have an order entry form that runs off of a query.  It started off with
just using the unit price and it works fine.  But now my boss is wanting it
to reflect the correct price for the customer's price level.  I started by
adding Price level in my customer table to reflect which ...

Hi I have a memo field which some time has a fair few note in it.
I use the following to date stamp it
Me.Comments4 = Comments4 & "    " & Now() & " "
Me.Comments4.SetFocus

I have two tables, Students and Events which are joined using
referential integrity on the StuID field. I have a master form where
the user can choose the student to review by selecting their name in a
combo box and all their events are displayed in a subform. I want the

My company upgraded to Office 2007, except for Access, which is still 2003. A
form we've been using that I designed has been functioning great for weeks
now, until the upgrade. The form has a combo box (linked to another table)
from which a user can select his or her ...

I have a main form with tabs. On the Machine/Service tab I have Subfrom 1
that lists all machines owned by a customer, and subform 2 that lists all
service done on the machines owened by that customer.
Subform 1 is a continuos form showing each machine with model, serial#, date

Hi all, I have this event procedure after update on my form
Private Sub Combo109_AfterUpdate()
Me![SalesTaxRate] = Me![Combo109].Column(1)
Me![BusinessUse] = Me![Combo109].Column(2)

I have many fields text and combo bound and unbound in a form. Is there a
situation where the form has a new record and yet dirty or any other
unexpected possibilities. I always think that when a form is new it is
invariably not dirty. I am not sure if this is true always.