Query to Form

[junction]

I can't believe I've forgotten how to do this!

Basically, I have a form which is used to enter data (this also contains a subform but that's irrelevant!). I have also used the same design which opens when a query is run.

The thing is, I want to open exactly the same form when another query is run (to keep the format, text boxes etc the same) but my minds gone blank!



HELP!!!!!

[RuralGuy]

It is just a matter of changing the RecordSource of the form.

[junction]

Thanks, I'm getting there!

I've now changed the RecordSource in the form but when I run the query (which is just a date filter) I'm getting 3 records, which is the same amount of records in the sub form.

EG.

Main table shows OrderNumber (which is an autonumber) with other fields of DateReady, DateReqd, BookingRef.

The sub form shows Customer, GoodsType, StkCode, and Qty.

So, there can be several Customers for one order number.

Therefore, OrderNumber 1101210 has 3 Customers, DateReady = 21-Dec-10.

When 21-Dec-10 is entered in the query this brings up 3 x OrderNumbers, should only be 1.

[RuralGuy]

You know that Forms run queries, not the other way around, right?

[junction]

Yes, I'm aware of that, I have written the query and everything works ok.

When I open the Form I enter the appropriate date (in this case 21-Dec-10) which should bring up 1 record of OrderNumber 1101210 with 3 customers in the subform.

Somehow this brings up 3 records of OrderNumber 1101210 with 3 customers, in other words it's duplicated by amount of customers in subform.

[RuralGuy]

Are you using a Form/SubForm arrangement? Have you seen this: http://allenbrowne.com/ser-36.html

[junction]

Yes. There is a Form and a SubForm.

The relationship is OrderNum in tblPage1 (main form) and OrderNum2 in tblPage2 (subform).

[RuralGuy]

To what do you have the SubForm LinkChild/MasterFields properties set?

[junction]

Link Child Fields = OrderNum2
Link Master Fields = OrderNum
Enabled = Yes

[RuralGuy]

Just an aside but it is easier to understand years later if the fields have the same name. Do you have your NavButtons turned on on the MainForm? What happens when you just move from record to record on the MainForm? Are the SubForm records limited?

[junction]

The NavButtons are turned on on the MainForm.

After the query is run the MainForm says Record 1 of 3, the same as the SubForm.

When I click right for the next record it is the same as the previous record.

[RuralGuy]

Something is not right. Can you post your db so we can look at it?

[Microsoft Access Database]

It sounds like you do not have the correct keys in your query used to link the subform back to the main.

[junction]

The only forms you need to view are:

frmQuery1
frmQuery2 (which is the one in question)

The Queries are:

tblPage1 Query for frmQuery1
qryFromToDateReady for frmQuery2

The rest of the database needs tidying up so ignore everything else.

[RuralGuy]

I do not see a SubForm on your frmQuery2 form.