Hi,

I have a table with the following fields:

InspID(AutoNumber)
Crane Number
RepairID
AreaNumber
Date Of Inspection
Crack Length
Image Path
Inspector Name

The main fields I am looking to update is the Crane Number and AreaNumber.

A form should be able to update this 2 fields, the rest of the fields can remain blank. The Crane Number field is linked to another table where a list of Crane numbers are stored and I am thinking of using a combobox for the user to select a Crane number to update. They should only be able to add 1 crane at a time.

1 Crane Number should automatically add 82 area numbers into the table. The 82 area numbers are stored in another table called Area Number.

Is there any way to do this, and if yes how?

Thanks

I am not sure what you are trying to do, but it sounds like something you would first do at the table level. You need to make the CraneNumber a look up value to the Crane table. Then when you create your form, you will automatically get a combo box for your users to look up a crane number.

Then I am not sure what you want to do next. Do you want the AreaNumber field to contain 82 separate numbers, or do you want to create 82 new records? If your Area Numbers are already stored in another table, you can make that a look up column as well.

You could just write some simple code to insert 82 records after the user selects the Crane number. I would do this with an unbound form, however, with a combo box that looks up the crane number, and then a commit button that adds the records.

Do you have more info on what you want to do?

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com