Help needed please

[Guest]

Simple example.
I have a Customer table and a form linked to this table.
On the form is a combo box.
The combo box is unbound and contains the Customer Name and the Customer ID.
The Customer ID is hidden in the combo list but it is the bound column.
When the form opens it displays all the information for the first customer
but it does not show the Customer Name in the Combo Box.
This is blank.
When you click the button you can see that the first entry is the right
Company Name and when you select it the detail on the screen remains the same.
How, when and where can I poulate the Combo Box with the first company name
so that it is not blank?
What are the names or how do I refer to the seperate entries in the Combo Box?
Is it Value, Column, Text, DefaultValue or what???
Any help would be great.

 

[Guest]

Not quite sure about this one (bit confuzzzzed).
1st thing to do (if I understand right that you want to link the subform
with the details on the main form) i to ensure that the LinkMasterField and
LinkChildField are in fact linked. If not press F1 and type LinkChild for
details.
You can refer to any column in the combo box in any unbound field by
refering to the column (e.g column(1), column(2) etc) if you are getting a
blanc then alter the refere to column by altering the column width (remember
that you see the 1st coloum with a size of more than 0cm but thi not affect
the bound column).

 

[Guest]

Thanks Wayne,
I never mentioned a subform.
It's just a simple form with Customer Name and address.
The Name field is a combo box rather than Company Id.
Users don't want to use record navigation to go through each record until
they find the customer they want.
Hence I have made a combo box that lists the customer names.
If I make the recordsource of the form = the customer table then it displays
ok but I cannot select anything from the combo box.
So the form does not have a recordsource.
The only thing wrong is that when the form is opened it shows the address
etc of the first customer but not the Customer name.
The question is.......how can I open the form and populate the customer name
field of the combo box with the first Company name?
Regards
Tezza

 

[Guest]

Tezza:

I have found the best thing to do is create a query from the table you are
talking about, then put in the customer id field and the customer name field.
Once that is done, go back to your form and make the record source the
query, then on the order by field inthe properties of the the form type in
the [tablename].customerid. Then make sure that the wizard is
selected(turnedon), it is the magic wand, make sure your fields list is
showing, then click on the customer id and then click on a new combo box.
This will ask you what you want to do, then select the first option, from
here you will be able to select customer id numb by typing in that box and it
will automatically fillin. Now do the same witht he customer name. Then in
the details section, go to the tables section, click on the table that will
link to that query, such as customer orders, drag and drop that table in the
details section while in the design mode of that form. It will ask you a
question, what you want to do is link tot he customer number field, select
your own field to link. What this is askingis when you do a search for this
form what do you want ot link to the subform using, well customer id or name
is the best here.

I am learning as i go, but the book ACCESS 2004 for dummies has helped me
tremendously.

Judy