I'm relatively new to Access and I'm having trouble with controlling records
in a subform.  
I would like to navigate through subform records using a button located on
the main form.  I have tried using "GoToRecord" in a macro but get the

Hi All! Been working with a form and 4 subforms. All the subforms have an Add
New Record Button. Now, when I put fake data into the form, click on the Add
New Record Button, it gives me this error "You can't go to the specific
record". I don't want to go to a specific record. All ...

Lets say you have a main form that displays the business' information.  You
then have a subform that displays the owners info as there could be more than
one owner, which this subform points to a seperate table, for this reason.
How do you search this subform or subform (table) ...

I am trying to type info into a cell and it will only let me type in about 25
characters.  How can I get the cell to hold more characters?  This is in a
form.

When ever I try to add a subform into a form I get this error message when I
try to leave design view:
This expression is typed incorrectly, or it is too complex to be evaluated.
For Example, a numeric expression may contain too many complicated elements.

I have a form which shows 900 property names.  I have added a button next to
the property name that when clicked will display more detailed information
about the property.  I would like to have the form display 2 or 3 columns
(across then down) rather than having to scroll ...

I’ve built a form that can be divided into two parts. The left-hand part is
for the user to input certain criteria in the textboxes for searching, after
clicking the “search” button, then the relevant search results will be shown
in the right-hand part of the form. I’ve successfully ...

I want to search my db for boats between 20 ft and 65 ft on a form. I use a
continuous form with search parameters at the top and the results shown at
the bottom.  How can I use a text box for the Min/Max values.  The field is
[LOA] and contains the length of each boat.  Any help ...

Im not sure if this can be done but, i've got a form with many fields
(textboxes and combos) if a user begins to complete one textbox - i want 6
other textboxes to 1) change colour indicating that they must be filled in)
and 2) have a msg box appear if any of the 6 boxes is not ...

I was wondering if someone can help me out -
I have a database that stores employee information. When a user enters
details regarding an employee, i would like a textbox to be able to
automatically store the name of the user who has entered the details on the

I have several tables of "master data" that feed into a "Daily Roster Report"
of assigned route drivers, routes and truck assignments and scheduled start
times.
I need to be able to update the Daily Roster Report each morning to refelct

Has anyone seen this behaviour previously?  I have a form which contains a
subform both of which are populated by queries.  If I go into the Form's
design view, *then* go to Form View the form is displayed fine with the
correct data returned from the queries.  BUT if I go direct ...

I am trying to make a datbase that a prints report that will be used as
an invoice
I am trying to eliminate the need of typing the same clients name,
phone, fax  in every single  record. I have created a table

I have a combo box which locates a member record in my membership
database.
As I type the name appears in the box. In the case where many members
have the same last name I need to click the black triangle, (what is

On the second of two tabbed forms I'm redisplaying the name by concatenating
data from two fields from the first form. It works fine until I use a filter.
After applying a filter, I must click on that field or tab to it to get it to
begin displaying that data. Moving to a second ...