I use and option group to shown or hide many controls
in my form ( text boxes,labels,and a combo box).Is there
a way to bound these controls to a ( called frame ) so that
when we write the code, we just need to type this " frame "

I've generated a lot of labels but putting in a bunch of bound text boxes
that have table values as their  source, but now that I want to generate a
whole letter, with bound text boxes for the salutation and some embedded
text, I find I'm stuck.  If I create a large text box ...

I have no idea how to hide some controls in my subform
if value in a textbox in main form is >1 or =1.I can't write a code.
Please help.

I have been working on this problem for a whie and finally decided I
needed help.  I have a subform that deals with patient visits and one
field asks for weight. I have a another subform that deals with
medications...I need the patient weight from the clinic visits subform

I have this code on a form to tell me how many records are in the form
="Looking at " & Count([CallID]) & " Calls Scheduled in this Query"
(displayed above my navigational buttons)
And I have this code, to tell me how many records (or calls) are in

I am viewing my records in a subform in datasheet view.
How do I put a text box in the footer of the subform to sum the record
totals?
TextBox name of each record where the data is to be summed from is QTotal

I put the following  comand in forms load property to set some bolds and is
not working:
If Me.CodigoRubrica = "TOTAL" Then
Me.SumOfMes1.FontBold = True

I have a simple little DB that tracks my time and attendance at work. One of
the calculated fields on the form tracks the week number. I have a calculated
control with a default value of:
=Format([Date_Work],"ww")

How would I count the number of records in a database when I view my form
records in datasheet view?
Regards
John

I am attempting to make it easy for users to open a query by offering two
choices on sorting, by either Grant or Unit ID.  I've created a form to do
this, but I'm not sure of the language I need to make this work.  I already
have a parameter query set up that asks for the State, ...

I can't add a continuos form as a subfrom.Why?
Is there any way?

Can I create a form that will search a table for a specific record within the
table without changing the underlying table?  The tables have inventory for
parts.  I want to allow the mechanics to open a form and type in one of
several varaibles such as:  A part name or part number ...

I have three tables.
1.Model_tbl
   *) Product Name = Text ( PK )
2.Spec_tbl

I have two version of "main" Form (Form1... Form2) with Combo Box (Combo35).
From this form I open another form where Default Value in one Field (Text
Box) must be value from Combo35 in Form1 or Form2.
How to detect which form is open and use value from Combo35 in opened form

Been looking through the forums and learning a lot but don’t see this
particular problem addressed . . .
I am trying to update my combo boxes when new data is added.  Usually, the
updates need to happen in a form that is not the current focus.  (So that