Search results

Thanks so much for the help, you are a lifesaver. Now my stuff all works nicely!

I attached my database, the RecordSource is a query that Access automatically made, I created the form by selecting my Orders table and clicking Form under the create tab. After looking at the query I have realised that it is making new fields and adding it to the query, these are the duplicate...

Hey Vlad, First off thanks for the reply! My PaymentTypeID is a AutoNumber field and my PaymentType is a Short Text data type so I don't think it is the wrong data type, unless you are referring to some other kind of setting. When I right click on the Customer First Name field in my form and...

Just did some more testing and the duplication error also occurs when in my Customer Entry form. I also attached my relationships, in all relationships Enforce Referential Integrity and Cascade Update Related Fields are selected.

The circled area in the attached picture is what isn't working. I would like CustFirstName to be a combo box similar to Payment Type but for some reason when I add these fields it does not make a combo box like it does for fields from other tables. Also whenever I add the CustID field it...

Hi, I'm making an entry form for orders within my database and I wanted to have combo boxes where the user can select different related entries such as Customer and Product, I used the Add Existing Fields tool to add in these entries and it worked for my Payment Type and Product tables but when...

Hi, I'm new to Access and I'm trying to make an entry form for the orders in my database. I have been using the Add Existing Fields option to add the different attributes to the form and for the Payment Type a combo box is created where I can only choose from the given payment types, when I do...