Some of what you wrote is a little hard to follow, but I
think I can help with a few things (in no particular
order).
A bound form is one that has a record source (a table or
query). There are unbound forms too, but what you have is
a bound form.
A control is an element on a form or report that contains
data, displays information or decorative elements, or
performs an action. Controls such as text boxes and combo
boxes that are tied to the form's underlying table or
query are bound controls.
A bound control has a control source, which is a field in
the underlying table or query to which the control is
tied. If you view the field list (View on the menu bar),
you can drag fields onto your form. Once there you can
change them (use the right click menu > Change to) as
needed from text boxes to combo boxes or list boxes.
Combo boxes are drop down lists. A combo box must have a
row source, which is the source for what actually appears
in the list. If you intend to store the selected
information, the combo box is bound to a field in the
underlying table or query (the control source).
You can use the combo box wizard to add a combo box, or
you can create a combo box, right click and select
Properties, click Row Source, and click the three dots to
construct your Row Source query. Use the same three dots
to view the Row Source for a combo box created by the
wizard, so you can see how it works.
You will have a difficult time binding a control to a
field that is not in the form's record source. You should
add it to the query.
This is all getting ahead of things in that it assumes a
functional set of relationships between your tables. From
some things you have said I expect that your database has
some irregularities in how it is constructed. To get the
best answers, I suggest you post information about your
tables: their names, their primary keys, and some
representative fields. You don't need to post every field
in every table, just enough so that we can see what's
going on.
One more thing for now is that I recommend printing
reports rather than forms. You can save a form as a
report (File > Save As), then edit it as needed so that it
looks best when printed. There are many advantages to
doing this, such as the sorting and grouping options that
are available for reports.
-----Original Message-----
Ok, now Im stuck again. I have created the query below which combines the
[title] and [name] from [cats] table to create a [fullname] query with the
correct result, but I cant get the [fullname] onto my form where I enter the
rest of the cats details. I used the [cats] table for the form wizard and
when I call up the [fullname] from the query it dosnt go in. The names are
there to select but I get an error saying [fullname] is invalid. How do I
get it to link up properly? I have tried relationships by linking
[cats].Name to [fullname].Name but that doesnt seem to help.
When I select the table and row source in properties then go to select the
control source its still got the [cat] tables fields, not the FullName
queries fields and when I try typing in FullName it puts #Name? in the box.
the dropdown list is there but when I go to select the name I get Bound to
unknown field.
I seem to have this problem trying to put other fields onto a form that
arent in the table/query I select in the wizard. Another problem I have
which is similar is when I try to create a query with the cats table info
and the show ring info. Even selecting just [cats].Name and [Show].Name
they dont link even when I edit relationships and join SDate together which
is in both tables. I get the error: The wizard is unable to open your query
in Datasheet view, probably because another user has a source table open in
exclusive mode. your query will beopened in design view. Then in design
view I get type mismatch in expression.
I hope this makes sense. I would appreciate any help with this problem. I
do try to figure things out for myself first and have been struggling with
this problem for days.
thanks
Julie
Just thought Id post and let you know I figured it out thanks to someone
posting a reply to someone elses similar query giving an online tutorial
site. I was looking for something else and stumbled
across the answer to
my
own question:
FullName: [Titles] & " " & [NAME].....
Funny thing is its so simple now I know how!
Ive been on this database the whole day trying to
figure various things
out
and FINALLY something has worked at nearly midnight. Still got a long way
to go so I'll have plenty more questions.
Thanks guys for your help and support for us newbies.
regards
Julie
field. Like one
field gap inbetween to
allow possible at all to have
the
.
