HI There,

I have read multiple threads around using sub forms and looking up certain data in the sub form but I'm struggling to get anything to work.

My problem is as follows:

I have a main form called Service_Request and in this form I have a filed called "Account1" and a sub form called "Service_Address".

The "Service_Address" subform pulls through several fields from the "Service_Address form including the fields, Site, Building_Name/Number, Address_Line2, County, Post_code.  I also have a field on the Service_Address form called "Account".

What I would like is that when I select the "Service Address" subform drop down, on my main form, it only shows the address's that are aligned to the "Account1" field on the main form.

If I try to filter within the form then I get the following error  In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid

The Account1 field on the main form and the Account_Name field on the Service Address form both lookup the account name through a subform lookup.

Hope this makes sense ?

MattP