Trouble Understanding sources in my Forms

[vennardk]

Hello,

I am trying to update a database from access 97 to 07. For a novice,
it is quite a challenge. I am using the Northwind 2007 example to
help me fit all my pieces together. However, I have come to a stand
still...

I do not fully understand what a Control Source is. I have found that
it is typically the exact same as the Name of the combo box or what
not. This does not make a lot of sense to me.

Also, I am having problems with my record source for a specific Form.
Mine currently looks like:

SELECT Orders.*, [Orders Status].[Status Name], [Customers Extended].
[E-mail Address] FROM [Customers Extended] INNER JOIN ([Orders Status]
INNER JOIN Orders ON [Orders Status].[Status ID]=Orders.[Status ID])
ON [Customers Extended].ID=Orders.[Customer ID];

However it asks me to enter a parameter for [Customers Extended].[E-
mail Address] and then again for [Customers Extended].ID. If I just
click OK through both of those, it gives me a "Run-Time Error '2105':
You cant go tot he specified record"

Why is it asking me to enter a parameter?

Any info you can give a learning student of Access would be great! My
biggest problem is I am not sure what a Control Source or Record
Source is. Can soemone help spell it out? Thank you so much!

 

[Guest]

I assume that you have a table 'Customers Extended' with fields 'E-mail
Address' and 'ID'?
Try this --
SELECT Orders.*, [Orders Status].[Status Name], [Customers Extended].[E-mail
Address]
FROM [Customers Extended] INNER JOIN ([Orders Status] INNER JOIN Orders ON
[Orders Status].[Status ID]=Orders.[Status ID]) ON [Customers Extended].ID
=Orders.[Customer ID];
The only hard return is in front of FROM, all others are just word wrapping.

 

[Guest]

The recordsource is the table or query on which your form or report is based
on.

The control source is the field within that table or query that your control
( textbox, combobox, etc ) is linked to.

Access defaults the names of controls ( if the name is available) to the
name of the field when you create forms/reports with wizards or if you pull
fields from the field list box. But the name of a control can be whatever
the designer wants it to be, while you would still want the controlsource to
be a valid field from your recordsource.

Finally, Access prompts for parameters when you include a field reference
that doesn't exist. I would suggest you double check your tables to make
sure that [Customers Extended].[E-mail Address] and [Customers Extended].ID
exist with EXACTLY the same names.

Hope that helps.