Hi Fred,
glad you found the RECORD SOURCE property
you can only have one RecordSource for a form -- that is why it is
advisable to use a main form and subforms if you wish to display and
edit data from multiple tables.
p 5-24: Mainform/subform
you can use a query that gets data from more than one table as a
RecordSource, but if you do that, you may only be able to display data,
not add or edit it
"That is why I have been building backwards"
sounds like you just accepted the way the data was structured wherever
it came from -- this is usually a mistake
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day
*
FBrnstrmr wrote:
"strive4peace" wrote:
Hi F (what is your name?)
Sorry I forgot this question--- Fred (yes it really is) and I just found out
where to assign the control source to the form. Hidden in the top left corner
just as you described it. But... my form uses data from multiple tables as
sources to coordinate the address, combobox, dropdown lists, and another
cascading combobox requirements that I need for my new database records. can
there be more than control source and/or I also need the table to which this
info will be outputted.ie: my input table of addresses is larger than I need
for my own table, but it is continually being updated by an external group.
The table I am trying to create or "fill" is more of a timebased snapshot of
info regarding some of these locations. As owners change for example the
imported data will reflect that and my table will have to note the change
from then on but not change the historic record from the previous owners
name. So in short, I need mutliple records of the same address while the
date, ownership and other info regardig the address changes. That is why I
have been building backwards, I started with an externally updated database
table in which I can make no changes and need to create another for internal
use with the info gleaned from the first plus any information we require to
track as well.
"simply shows an empty box"
you must assign the form RecordSource first ... then you will see the
fields in the Recordsource when you drop the combobox for ControlSource
smile
~~~
Trim will work -- but any valid equation must start with =
if you use an equation, you cannot change the information, it will be
for display only
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day
*
FBrnstrmr wrote:
You are of course absolutrly correct, but I did so because the down arrow to
which you refer simply shows an empty box and so there is nothing from which
to choose.
(I am reading the form and report design right now, interestings tips there,
but the TRIM (command?) didn't work. I am trying to show a concatenated field
of 2 numbers but there is always a space, even after I left justified the
right hand (or second) number.
I am very grateful for all your help, please don't give up on me. Thanks
very much.
-F