A form that builds a table with a certain amount of records

[webfactoryuk]

I was wondering if it was possible (or if anyone has any better solutions) to create a form with a single text field that I can enter a number in say 32.

The form would then create a table with 32 records with the numbers 1 - 32 in.

Basically I want the user of my inspection system to be able to enter the number of 'locations' to be inspected before they start. Just so they dont lose count half way round.

I was thinking if I could make a form that creates a table and then have a combo box read from that table?

Unless I have missed a better way to do it.

Thanks in advance!

[June7]

Here is one way to try.
Private Sub textboxname_AfterUpdate()
DoCmd.SetWarnings False
DoCmd.RunSQL "CREATE TABLE ..."
For i = 1 to 32
DoCmd.RunSQL "INSERT INTO tablename (fieldname) VALUES (" & i & ")"
Next
DoCmd.SetWarnings True
Me.Requery
End Sub

Check this article about using the CREATE TABLE sql http://www.w3schools.com/sql/sql_create_table.asp

What do you mean by 'have a combobox read from that table'? How does that help with data entry?

[webfactoryuk]

That looks good thanks!

It helps because the user doesnt have to remember whats next in the report. The combo box will list the next step (location) in the report for them.

Cant think of any other way to do it?

Ideally I guess there wouldnt even be a combo box, each record would just be assigned a location and they would click next to move on or something but not sure if you have seen my other threads? Im already out of my depth lol

[June7]

Right, I see no purpose for the combobox. The records have no data so what would the combobox show?

How would each record be assigned location info programmatically? Isn't that data user has to enter?

The form could be set to move into next record after enter value in last field. Need to make sure the TabOrder property of controls is numbered correctly.

Not sure if I have seen other threads, will do a search.

[Mclaren]

This might work for me too. I need to ensure when a new record is created in the primary table, the linked table has exactly 14 records for each record in the primary table.
The only difference is for each new record in the primary table, i have to add records to the linked table.

Gonna go fiddle with the code.

Thanks guys

[Mclaren]

Worked a treat. Just removed the create table section.