I want to do the following in a form "A" with a subform "B" and a button
"choose contractor"
1. When i click "choose contractor" a new form is popping up, form
"contractors".

When I delete a record from the main form, a query that selects data for the
subform asks for a parameter value that is normally obtained from a toggle
button within the subform. How can I stop this?
This is the SQL of the sub-subform

I have encountered a little problem which I found some information about on
the MVP website http://www.mvps.org/access/forms/frm0022.htm
But unfortunately, I am not strong enough to crack the code and implement
this on my DB. Can anyone explain this to me in layman terms... where, ...

Everytime I try to create a from in Access in with the wizard I get this
message.

good day all,
I have a frmchecking acct that has ID, DATE, Description, Debit, CRedit,
and the pop up form has Acct Type, Reference, transaction notes.
I created a button to open the form to the current record based on ID, and

i am very new to access.
i have a form with one text box that pulls the client name from the main
client info form, and one subform that allows me to enter a client's
appointment date, appointment and appointment price.

For months I have been successfully putting jpeg images (using Insert Object
and selecting the file) into my Access 2000 database. All of a sudden when I
tried to do that I got the filename listed instead of the image. I thought it
might be a size problem, so I made a greatly ...

Hey all, I've been researching this all over the web and can't find too much
on relative path storing.
I'm looking to add a button that pops up a browse for file dialog where what
is selected, is sent to a text box.

I have an Orders main form with a subform similar to the Northwind orders
form but bigger. Both the main form and subform are based on multi-table
queries.
The subform default view is Datasheet and displays 12 controls. 3 controls

Hello..
I am somewhat new to MS Access and need some help with a data entry db.  I
have two tables each with a Primary key of FRMID_PK.  Table # 1  - Recipient
Table #2 - Response  ( one to one relationship ).

Question One:
When entering lengthy notes in the VB screen, how do I put a line break in
that does't mess up the code?  I'm really just asking for a line break to
make it easier for me to enter and edit the message box text.

Hi, ive been looking at the below code which i got from another discussion.
the code is designed to include the current year within the autonumber. The
trouble is im not sure at all where to put this code into my access 2003
database. i have a table with a field that is ...

I'm writing detailed instructions into a front end, to essentially idiot
proof the database for data entry people.  In that I'd like to know how to
put a paragraph break into a message box text.  Is there way to do this?

hey pros,
I have a record protection question.
If a user enters data in a subform that is a continueous form of records i
wanted to lock that particular record after the txtDate is entered.

I am using Access 2003 . I want to browse for a file and  attach the file to
the record.
For eg. details of a student in the .doc file should be browsed and attached
to that perticular student concern.When I click on the button/Image in the