I thought I had asked this before but can not find my post.
when I open a form that contains a subform I want focus to be on a fields on
the subform.
this is what I have tried:

I've been reading through the other requests and trying to follow along, but
I'm having trouble...
I have two tables - Persona Data and Incident Reports
I want the data entry clerk to use a combo box to select a student

I use a calendar control on my schedule form to select dates.  I work the
same day in three different office locations each week.  I want to have a
text box automatically display my office location based on the day of the
week selected on the calandar control.  This will ...

I need to email a reference # from a form.  I just need the ref #.  Is there
anyway to do this?  
Thanks
Linda

How do I joint 2 fields into one field without doing it in the table. As I
have read here, If Ijoin them in the table, and there are new enries for
field 1 and field 2, field 3 will not be updated unless I do an update query.
And I don't know how to do it anyway.

When i am trying to import data from another database i am running into a
problem.  It is allowing me to import all tables and queries however it will
not allow me to import forms or reports.  I can see the forms and reports
however it is greyed out and will not let me hit select ...

I have written an event procedure for after the cost combo box is selected
that if the value is NOT equal to 0 I do not want the field truckhours to be
able to be input and if it is 0 they truck hours can be input.
Private Sub cbocost_AfterUpdate()

Based on a previous post, I used [Forms]![Search Form]![MLO #] in my query to
refer to my form and put a command button to run the query.  The MLO # is a
catalog number in the form of ####-####.  I am able to run the query for
exact matches to the entire field but it doesn't work ...

I have a form and a correlated sub-form. I want to prevent the data enterer
from modifying the form unintentionally when he clicks a check box
"Completed". I tried some simple VBA in the "Completed" control's "On Click"
property but it had the effect of also freezing the user out ...

Hi. I need to build a form the has some options to make wich will after the
filter/criteria for queries.
my olnly question is that I have to build something that will allow me to
from a list of deprtments wich one I want to print.

I want to open a form based on a table to only view certain records, for
example, paid customers only.  I tried to base the form on a query but it
didn't work.
Please could you advise on how to do this?

I have a drop down combo box on my form with names and whenever you choose a
name in the list it displays record below (in the subform) for that chosen
name based on a customer ID that links the combo box to the records in the
subform below. However when i first open the form it ...

I have a field on a form that i want to be able to enter a number in decimal
format and keep it exactly the way i enter it (ex: 155.5). However the field
is automtically rounding the number off to 156 or 155. I've played around
with a few format combinations but it continues to ...

I made a database, and a form to enter info into the datatbase. The form has
2 tabs, but both tabs enter info in the same table. The problem is that when
I go to open the form, it opens to the next entry, but the bottom record
counter is at 1. I can't go back and edit past ...

I've been working on a form and was testing it out, then for no reason when
ever I try and bring up the form it sets there of minutes and then finally
Access shows not responding.  I've tried stepping through the form, it goes
through the open section with out any problem and ...