Multiple entries from one form

[Acropolis]

Hi,

I need to create a form that will allow the user to enter details about say a water meter - make, model, size for example.

These will be from combo boxes.

Each time the form is opened though, there could be a different number of meters to enter, from 1 to xxxxx

I will need to use this method for entries on other things as well, such as users and a couple of other things. Same basis just different information.

What I want to do is have a form where they enter the number of each thing that is going to be entered, so 3 water meters, 2 users. Then hit "next".

That will then open a form with the right number of spaces to enter the details for 3 water meters, or 2 or 1 or 999 depending on how many have been entered.

Anyone have any ideas? As apart from putting a look in and closing/reopening a single entry form each time I'm running out of ideas.

Thanks

 

[Galaxiom]

Use a Continuous Form.

 

[Acropolis]

can this be set only allow x number of entries?

 

[Galaxiom]

I think you need to take a step back and tell us about your data structure. How are the tables set up?

 

[Acropolis]

It will be used for recording and processing orders, then the fieldworks jobs associated with it.

An order is created in tblOrders

Part of that order information will be how many meters are to be connected. This could be between 1 & ?????. It then needs to create an entry in tblMeters for each meter for the order. So if 1 meter then 1 entry, or if 5 meters 5 entries - one for each meter.

The information required for each meter is:
MeterModelID - Link to tblMeterModel
MeterSerial - text field
MeterSize - text field
MeterLocation - text field
OrderID - link to tblOrders

The form needs to be really simple and just ask for the meter make, (which comes from another table, but doesn't need to be stored as tblMeterModel has a link to the make so can be got through that if I need it), meter model, size and location. The other information will already be know.

I don't really want to create a single form and open/close it say 3 times for 3 meters, I would a slicker way of doing it.

The same principle would then be repeated for system users, but using different tables, this is for a report which is sent to IT guys to create users in an on-line system we have for data reports.

 

[MarlaC]

It sounds like you need a continuous subform to tblOrders to enter related data in tblMeters. You can limit the number of records allowed to be added to the subform with a check on the Before Insert event of the subform that the number of records doesn't exceed the number specified in the order.