Updating NON sequencial records

[smehnert]

Underlying tables - Farmer, Field(as in crops)... Each Farmer has about 30 fields.

In a form I want to select a Farmer and then be presented with a list of his fields... I then in two text boxes want to put a date and a product name (weedkiller)... Finally, I want to select some (NOT ALL) of the fields using a tick box or similar, then press an update button and then each of the records for the fields are updated with the product name and date...

Please help I do not know where to start?

 

[Pat Hartman]

I've posted a database sample that might help you - http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54924

It shows a meeting attendance application. On the attendance form, you select the meeting date and then select the attendees from a multi-select listbox. The code inserts a record in the attendance table for each attendee selected in the listbox. In your application you would insert a treatement record for each field selected.

 

[smehnert]

Star

PAT Thankyou... you are a star