2 issues with my form

[Grek]

Hello,

Currently experiencing 2 issues with my database

1. Do you know why in my form “F_MainSearch”, I can not see 4 records in my sub-form, but only 3?
It seems that record with UniqueID 5 does not appear in the list (you can see it by viewing the table T_NewLaunches)

2. Do you know why my combo box cboCreateNewEntry only returns 4 choices and not 7 as per the lookup values in field “Event Type” of T_NewLaunches?



Many thanks,

[June7]

No. 1 is because the RecordSource for Q_NewLaunches subform is an INNER JOIN of the table T_NewLaunches_IMTasks and query Q_NewLaunches

No. 2 is because the combobox RowSource is a query to T_NewLaunches table, not the ValueList that is set up in the table.

[Grek]

Thanks June07!

For #1: I made the change and it worked. However now that I decided to include an additional field “IM Name” from an other table in form “Q_NewLaunches Sub Form” , it returns – again - 3 results instead of 4. I really don’t understand what is wrong? I added the field “IM Name” in my query “Q_NewLaunches” so would expect to see the 4 results? What’s the logic for the query to return 3 results, and one in particular is not displayed?

For #2: Got it – thanks!

Many thanks,

[June7]

The query Q_NewLaunches is an INNER JOIN.

[Grek]

Thanks June07 - Not sure to fully understand what it means though. What do I need to fix?
Many thanks,

[June7]

An INNER JOIN requires that the linked fields have the value in both tables. So only records that match will retrieve.

You need to change the JOIN TYPE for this query to be 'ALL records from T_NewLaunches and those from T_NewLaunches_IMTasks that match'. I think this will be a RIGHT JOIN. I don't have your project or Access2010 here so can't verify.

With the query in Design View, double click the line linking the table/query objects and edit the JOINTYPE.

[Grek]

Works fine! Many thanks