I am trying to force a requery upon the main form activation.
I want to double click to add a new contact, which is listed in the subform.
On double click I have an 'add contact' form open.  After filling and
closing, the subforms are not listing the new contact, which tells me ...

This one's driving me crazy.  I've got a tab control with a subform on
each tab. each subform has a check box. I can access the value of the
checkbox on the first tab, the syntax follows;
Forms!frmMain.sfrmQuoteList.Form.chkCurrentQuotesOnly

I have seen this covered a few times, but I can't find a solution for me.
I have a form with an unbound subform. The user selects a record from a
search subformat the top, which sets that eord as the filter for the main
form, then hits a command button that binds the unbound form ...

This code support only (Numeric value) can any one covert this code to
accept (text value)
==================================
The code

I have a checkbox field on my report. Whether the checkbox has been checked
or not, the black border still shows on the report. Is there a way to show
ONLY the check mark if yes and blank NO border if no?
Thank you!!

I have a form called 'player' on that form there is a sub form called
'classschedulesubfrm' inside the subform there is a lookup field that runs a
query on the 'classes' table.
on the main form 'player' I enter a persons class schedule if there is a

If you have combo box with this List:
1
2
3

I'm using the following code in the BeforeUpdate of the form
to confirm data changes:
Public Function ConfirmDataChange(Cancel As Integer)
   Set frm = Screen.ActiveForm

,I need to make a text box Required - But not all the time!!
If another field "A" is not blank make field "B" required...
Something like this, but "Required" obviously, does not work!!
If Me.CA_NAME <> " " Then

Hello and good morning,
can some help me in where i am going wrong,
I'm trying to sort records in a certain way, but its not working,
I Created a query which represents a table and on two fields set as

I know basically how DMAX works. This is what I have so far.
LastPrice: DMax("[in_vpbrk_effdt]","ingres_in_vpbrk_tbl")
where in_vpbrk_effdt is the date. The date is in this format
12/12/2007,  I run a query on the table then run another query off of

I am sure this is simple for most of you but I am stumped.
I have a form PT_Demog that needs to open another form PT_MedBasic
I created a button using the wizard to open records with Patient_ID.
Private Sub Medical_Form_Click()

I hate to ask this again but I didn't get a response so I thought I would
post my code to help decipher my issue. Below is the code I have in a Command
Button and it works perfectly! All I want is to be able to add two people as
BCC and I tried everything but it won't work. If I ...

Alright, this is driving me nuts. I have an unbound text box (txtAddInvoices)
on a form (A2003) where a user can enter an invoice number and the code in
the After Update event creates a recordset clone and looks for the invoice
number. If a match is not found it displays a ...

My Objective:
User enters data in a field on a form.
The form has a subform.
When data is entered, only 2 choices appear on the combo box, on the subform.