Recent content by jnvcdfhj

Even if i dont attempt to pull information from the contacts table just equipment it still only displays the first record.

SELECT Equipment.Quantity, Equipment.Make, Equipment.Model, Equipment.[Full Description], Contacts.CompanyName FROM Contacts INNER JOIN Equipment ON Contacts.[ContactID] = Equipment.[EquipmentID];

I select the table everything is stored in but only displays the first record. On the form itself it displays everything i need but not when i do the query.

Hi all, I am running a query to collect information regarding equipment which is stored on a continuous form. When i run the query it only display the first entry not all? Any help is appreciated.

I have tried all the code you have provided and neither is working. This one .Findfirst "[ContactID] = " & Nz(Me![combo439], 0) No longer takes me to the first record ever entered on to my db but just remains on the current record i was viewing.

I have the following error.

Hi, Please find attached.

Hi all, I have a customers form and each new customer is given a contact id which starts from 18 and goes up to around 700. The contact id is displayed on the form but cannot be edited or removed to navigate to another record. In order to flick from record to record i have a quick find drop...

Hi, Thank you for your response. I will have a look at the relationship in this field then as the account number can have more than one record. The data is not from an excel spreadsheet the form is set to display as a data form. It was previously displayed as a continuous form however I...

Hi, Many apologies, I have included some new screenshots. The last one is all the data it should show under that account number but it is only showing one not all.

Hi all, I have two tables and require the records to appear when I run a query. One field of from a table called CLI and the other is called Equipment. I require the field AccountNo from the CLI table to correspond with four fields from the Equipment table. The equipment form is a corresponding...