Combo Box Wizard > Store Value in this field?

[PBS]

Hi I'm making a main input form that has quiet a number of combo boxes on it but I've come to the next on the list
So I've gone
Combo Box Wizard > Store that value in this field
But the list of fields in the drop down does not include all the fields in my table (the table has 100 fields or so.)
So the question is how to I see the full field list to choose the field I want to use the results of the combo box with?

 

[boblarson]

First a sanity check. If your table has 100 fields or so, I can almost guarantee that your design is flawed. It may not be but normal databases rarely get over 20-30 fields in a table. I would find it interesting to see your table structure.

Next, you don't need to worry about the wizard. Just click Cancel when you put a combo on there. Then you can go to the properties dialog and set these things yourself:

Control Source - field in the table/query it needs to be bound to, leave blank if unbound is wanted.
Row Source - Select the table or query you want or create a query by clicking the Ellipsis (...) that appears when you click into that property and then build a query (don't hit save but just close it and say yes to the question asked).

Row Source Type is normally Table/Query but can be a value list if you aren't using a query or table or SQL statement as the row source but are populating with items separated by semi-colons. Table/Query is best because it is dynamic.

Column Count: should be the number of fields in your row source query or table.
Column Widths: should be set so you can see whatever field or fields you want. You can hide a column by using 0" and show it by using something other than that (no negative numbers). 0";1";0";0";0" would be showing the second column of a five column row source and hiding the other four columns.
Bound Column: this is the column number which provides the value for the combo, and is usually set to the first column which is normally the ID field.

The Store This Value in this field is just saying it is a bound combo box and the Save Value for Later is an unbound combo box.

 

[PBS]

Hi Bob,
I'm basically converting a paper form managing production inputs in a manufacturing plant into a database.
So i've basically took all the data entries from the A4 sheet of paper work and put them into one table it has only one quay field so all the date relates to that one field.

-----
I've just tried your idea but the control source only list the first 27 fileds in the table as well??

 

[boblarson]

Hi Bob,
I'm basically converting a paper form managing production inputs in a manufacturing plant into a database.
So i've basically took all the data entries from the A4 sheet of paper work and put them into one table it has only one quay field so all the date relates to that one field.

-----
I've just tried your idea but the control source only list the first 27 fileds in the table as well??

Before you go further - Get some help designing your table structure properly. You do not have a properly normalized database. Go post the question in the Database Design and Theory category and post a list of your fields from your table. If you don't want to type them all in, you can use this function (just paste it into a standard module (and don't bother naming or saving it) Then just go to the VBA window and to the immediate window and type:

GetTFields("YourTableNameHere")

and hit enter. Make sure you replace YourTableNameHere with the actual name of your table.

Function GetTFields(strTableName As String)
Dim tdf As DAO.TableDef
Dim fld As DAO.Field
 
For Each fld In CurrentDb.TableDefs(strTableName)
     Debug.Print fld.Name
Next
 
Set tdf = Nothing
End Function

and this should give you a list of your table's fields in the Immediate window which you can copy and paste then into the forum post.

 

[PBS]

Cheers Bob will do