Not a terribly hard problem, just cant get it right.
Im trying to assign a combo box the value "Reset Form" after a different
combo is updated, so in my "after update" of a combo i have:
Me.cboOwner = "RESET FORM"

I am going to have a large enumerated list for one of my form's
fields.  Based on the choice made in the first field, I want the
second field to auto poulate a number.  This number coms from a
separate table that enumerated list comes from.  All the choices in

Hello,
I have a combo box that all of a sudden does not show the information from
the table I populated from...when I pull down, it is just empty, but if I
click on the empty space it shows the company that would be in that spot.

I'm relatively new to VBA. But i have adapted Allen Browne's Search form to
my main form. It works great. If I place the command btn on the main form
with this code
Dim strWhere As String

I have the following:
frmMAIN w/subform of subDEFENDANTS
frmNEWPROPERTY w/subform subNEWDEFENDANTS
When I enter a new property on the frmNEWPROPERTY form and close that form,

I have a continuous form to add new records (Table==>Query==>Form). However,
if I select from the record selector a record and delete it, it deletes from
the form, however, when I look inside the table the record is still there.
How can it be?

I have a text field that has the is hyperlink property set to yes.  When I
click on the hyperlink I get the warning about hyperlnks being unsafe, blah,
blah, blah.  I need to use a text field because my data is coming from SQL
(no hyperlink field type in SQL).  Is there a way to ...

I want to cycle a group of records in code to create a PDF file from a
report and then email it. however, when i click the button on the form to
accomplish this i get an error. "Object Required" in the SQL statement that
is trying to set the recordset.

I would like some suggestions on the best way to make this work.  Two forms
based on one table.  Main page has shorcut button to second page.  Main page
form contains Customer First Name, Last Name and address.  Second form
contains First Name, Last Name and history of purchases.  ...

Hi,
I am trying to apply a filter to a form in a Access 2007 project in VBA.  
The filter string is being generated correctly but it is not being applied to
the form.

I never had this error before.
This hapens now in this instruction:
DoCmd.TransferSpreadsheet acImport, 8, "NewTable", Me.txtFilename, True, ""
Is it an access problem resolving with a simple shut down?

I have a form that can generate another form with some of the data going to
the new form.  The new form generates a new ID number which I want to retain
on the original form.
I tried this code line to get that result but I end up with an error-

Is there anyway that I can have the splash screen appear at the same
time that the users are required to login.  I want the splash screen
to contain instructions about how to log in.  To be specific, I would
like the splash screen to remain up after the person has logged in.

I have 4 file status' - ACTIVE, PENDING, SOLS and REJECTED.
I wish to make a field called DiaryDate compulsary if Active or Pending is
selected.
Could someone please advise me how to code this?

What's the difference?