I am trying to have my text blink with the following:
Private Sub Form_Timer()
Me.VendorName.Visible = Not Me.VendorName.Visible
End Sub

I thought this would do it:
I put this in the before insert of the subform:
Me!txtJobID = [Forms]![frmInvoice]![txtJobID]
frmInvoice is the main form.

I am trying to filter a subform by clicking a buton in the main form.  Here
are the form and filed names:
Key:
Main form = frmMain

I am trying to do the following with a button located on the main form:
  1 - Transfer control to the sub-form
  2 - Allow additional records to be added to the sub-form
The main and sub-forms both have the following parameters set "on open" :

I'm using a method from Allen Browne's website (
http://allenbrowne.com/ser-24.html) to call values from fields in a previous
record and use those as the default values for a new record.  The form that
I'd like to have those default values in, however, has only one record: the

I have a field on my form that is called "Job Number".  I would like it to
increment automatically each time a new record is created.
Ideally, I'd like it to start with the number 1 at the start of each new
day.  But if that requires a lot of programming, then I would just be ...

I would like to get a code or advice on how to get a form to pop up when the
user choses a certain choice form my main form.
For example.
On my main form I would like the user to chose if they are employed or

I could not find any MS help articles on this Command. I wanted to replace a
DoCmd.SendObject method but can't find any info on the properties to set.
Thanks.

I am working in a form that has 2 list boxes, I need to be able to select
items from list 1 and drag and copy the selected items into list 2.
I found a module in Microsoft page that does something very similar to what
I want with the exceptionm that this code removes the selected ...

I have query contain 2 fields date of birth and today date and on calculated
field name calcdateofbirth
I want to know the the date of birth of any body by year and month
i can use this expression to calc the date of birth by year only like this

I'm having difficulty executing the following sql statement.  Can someone
tell me if my syntax is correct?  Do I have missing double or single quotes?
The date function I'm using takes what the user enters on the form as lets
say 06/26/2006 and converts it to a Julian date like ...

I have a form where I would add how many openings there are for each
position. Once I get the total I can see it on my form but I am not able to
transfer that total into my table.
My code for this text box is

I'm having a problem with Requery.  I have 7 combo boxes that are cascading.
One gets it's data from the previous one.  The first three requery and blank
out the combo boxes if the item that was selected isn't in the new list.
Although the last four do requery and get a new list, ...

I have a tabbed form. trying to get nested subform on 3rd tab to open to new
blank record, and want user to have ability to scroll previous records.
this is my code:
Private Sub Form_Load()

dear friends,
i have an Open_up form with many command buttons on its header.
form based on a fields  
                             1)   loginname