I was just wondering if it would be possible at all to link up a text box on
a form to input data to multiple fields, these being in separate tables all
within the same database?
So far I have found out that I need to click on the text box whilst the form

I have a form which displays 20+ rows in tabular format when invoked from a
pop-up form. I would like to populate 6 unbound fields for each record
correctly once the form has displayed the data and before the user has
started to move around the form. The population involves ...

I have a form with 2 controls [BeginningDate] and [EndingDate]  I'm trying to
set the default for BeginningDate to 01/01/2005 and the EndingDate  to
12/31/2005.  No matter what I do,  I keep getting the date of 12/30/1899.  
The controls are formatted for short date and the input ...

Is it possible to have the result of a query as a caption on a buttion.
Ie. I have a query which returns a numeric value and would like this number
presented on the button
Thanks in advance

I need to run several (32) Append Queries to build one table. How would I do
this with Visual Basic and one "Command Button'? I know how to do it once:
Private Sub Append_Button_Click()
On Error GoTo Err_Append_Button_Click

I have a popup form using a combo box to allow selection criteria, which then
calls a form using Openform with a Wherecondition clause containing 2
conditions(year = 9999 and period = 9).This works ok.
I copied the pop up form to another pop up form and used the exact same code

I’m having some problems doing this:
-I have got the Form1 that has a field called “name of the company” that is
a Table/Query , where I can select the company I want and then open a Form2
that has got detailed information about that company (without close the Form1)

I have 1 main table that has AutoNum, MemID, MemName, address, & a few other
columns.    The 2nd form is suppose to go to the Products Table.  What
products were added in.   Both tables needs to pull in the Autonum from a 3rd
table.

When printing a for I'm getting horiz. lines and small boxes showing up.  I
can't find them to get rid of them.  Any idea where they might be coming
from.  They don't show up on the form in design or form view nor on a print
preview, but only when printed to paper????

Hi, i need some help
i have a subform, and with the subform, there are 2 Record Navigation Bars.
I want to get rid of one of the Record Navigation Bars. Could you please
tell me how to do that???

When entering information in my database, following procedure followed:
1.  Create customer information
2.  Create product info if not already entered
3.  Enter order for customer - product, quantity, description, price, etc.

I am creating a database for auditing purposes.  I am fairly new to Access
and am not sure I am approaching the problem from the best angle, but here is
what I've got....I have a form with many combo boxes (over 100) that are
bound to fields on the main table.  The values that ...

I have a combo box on a page 1 of a tab control.  If a certain item is
selected in the combo box, it will trigger a messagebox(VBYesNo).  If the
click is yes, I want the tab control to go from page 1 to page 2.  If the
click is no, I want to set the focus on a text box within ...

I have a form with a subform, while i'm updating the subform the screen is
kind of blinking (going off and on for the sub form only ... the form itself
does not blink)
I would like to know if it's possible to freeze the screen while and only

I have a combo box on a page 1 of a tab control.  If a certain item is
selected in the combo box, it will trigger a messagebox(VBYesNo).  If the
click is yes, I want the tab control to go from page 1 to page 2.  If the
click is no, I want to set the focus on a text box within ...