Access 2003 - Unbound Tabular Form

[LSM1604]

Hi,

I have a database which is to issue and return items out of a loaned items store.

Ideally I would like to be able to issue multiple items at once to one person.

I have created a form which searches for the employee based on the input employee ID. The form has 10 Item ID fields in which data can be added to any of the fields and when the submit button is clicked, the item details are updated to issued and shows who has the item etc.

However, this is a limited form, and I could increase it further, however that means that the code would increase because I have wrote a piece of code for each of the item fields. (I am a novice with Access and VBA, so I have a very limited knowledge).

I have realised that a tabular form can be used, and that it has one item ID field, and once entered, another field appears. I assume that no matter how many items that I add to the form, then click submit it would issue all of them items to that user? The problem I am having is that I cannot work out how to issue one item, let alone multiple items. Would someone be able to help me with this please?

Thanks,
LSM1604

 

[Uncle Gizmo]

The form has 10 Item ID fields ).

I am revising my answer because I assumed this line meant you had "10 fields" in a table, one field for each Booking.

I realise that this assumption might be incorrect, so please could you confirm how your bookings are stored?

 

[LSM1604]

Hi.

Thanks for the reply.

The table has around 3000 records and will expand.

The form that i have made already has 10 fields, which when a number is entered into one of the fields and submit is clicked, the record is searched for and then updated.

The reason for the 10 fields on the current form is because it is highly likely that more than one item is issued at a time, therefore speeding up the process. So, if 6 items are scanned, then submit is clicked, each of the items will be searched for and then updated individually.

However, it would be beneficial to have more than 10 fields available, hence my thinking to make a new tabular form.

Thanks,
LSM1604

 

[spikepl]

If all of your data is in one table then there is a problem. Your issue is similar to an order form: an order consist of customer data, date, and then a list of order details, where each detail is a quantity (in your case 1), itemID (what was ordered), price (probably irrelevant in your case).
So you'd have a table tblLoans (containing loan date, return date, "LoanerID", and tblLoanItems (listing arbitrary number of loaned items for each loan) - ie a form and a subform.