Recent content by jimkerry

me again My database contains information about various dwellings or properties and the works required to maintain certain aspects of them. Most of the information in the database is linked to an address table (call it tbl1) with a unique property reference number (UPRN). Some tables contain...

Cheers Thats not the problem. Its the list box on the subform which I want to point to quotes received for a property (house etc). The subform is already linked on Child & Master fields to the main form. HELP!!

I have say information about buildings and repairs to these buildings in a database. The details of each property (property as in house/ flat etc) are available on the main form. Various works are required from time to time to maintain the condition of the property and quotations received from...

brilliant - thanks guys so onomatopoeic (not) tho on reflection ..... cheers onto problem b

Sorry, I'm not actually moving any data - I'm just scrolling through the recordset and want to create an event which refreshes data in a linked list on the same form containing related data.

What form event occurs if any when the data in a form moves from one record to another?

Thanks VBA.. It's not the nr of records I'm trying to manage -I'm trying to select (limit) the records for the List where the data in the linked field on the main form/ sub-form (child/ master field) are the same or are identical.

I have a List box on a sub-form which will find records on the sub form based on the value selected in the list box but want to limit the records available in the List box to the Child field on the sub form that is matched to the Master field on the main form. Can I adapt the code on the...

I have a List box on a sub-form which will find records on the sub form based on the value selected in the list box but want to limit the records available in the List box to the Child field on the sub form that is matched to the Master field on the main form. Can I adapt the code on the form...