Replies

I solved the problem -User Stupidity- before you posted.
You’ve been a great help.
Apologies for any wasted time.

Rob

My driver table contains three records! If you have the inclination, perhaps you could enter a dummy record in to the table and test the query. In the meantime, I am going to create a new query to do the same thing and check it out.
Very mysterious.

Thanks again for your help. It’s really appreciated.

Rob

Thanks Steve,
Point taken. Would you look at the query -qryDriverID-which was working correctly but not any longer? Running the query in the QBE grid only works for record number 1 and returns nothing for the other 2.
I am at a loss to explain the problem.

Many thanks again,

Rob

Thanks Steve for your input. However, I do not wish to display all the orders made by an individual customer. I want to select a Customer ID whose source is The Customer table then have the subform display the Customer details. The Customer ID for that order is then stored together with the rest of the order in tblOrders.
I think I’ve sorted out the subform behaviour (a matter of requerying). My problem now is that a query which once worked properly is now misbehaving.
Please take a look at the amended db and advise me on the problem and solution.

If you think I need a complete redesign, I’ll do so.

Rob

Hi Wendell
I am actually trying to select a record from the Customer table based on the Custmer ID.
I still don’t understand the subform’s behaviour.

Thanks for your time

Rob

John
I am unable to post an attachment because, despite compacting, I cannot get it less than 216K.
It consists of 4 tables(empty), 1 query and 1 form/subform.
This doesn’t seem right.

Any ideas?

Should I build the whole db from scratch?

Rob

Thanks yet again for your time, John.
I’ll attach a cut-down version as suggested sometime tomorrow.
It is so frustrating when one thinks one has it cracked to be presented with problems which shouldn’t happen.

Regards

Rob

Confused. I’ve recreated the form and subform from scratch. When I open the main form, the previously selected record is displayed in the subform. If I select a new Customer ID the subform does not change. However, if I close the form then reopen it, the new Customer details appear in the subform.

Can anyone help?

Rob

Thanks for getting back, John. Both Link Child Fields and Link Master Fields properties show the value which I presume is correct. I don’t think I’ve changed anything, but…..
Should I recreate the primary form?

Rob

Good grief! That was quick.
Thanks Mark and John.
Yes Mark, I was confused but shouldn’t have been. And John, I had played with the subform idea but I couldn’t quite get it right.
Perhaps you could help with both ideas in order to further my education.
Secondly, if you could take a look at my previous post (200965) regarding the mysterious behaviour of a subform, my grate will never be so full.

Many thanks,

Rob

Thanks Mark for the quick reply and offer of further help. I would imagine that the list box option would require the user to click the arrow to view the list. While this is perfectly acceptable, if a box could show a list of previous treatments without further input from the user, it would be more aesthetically pleasing. Also it would challenge and inform me. If you would expand on your second option, I would be extremely grateful.

Rob

Thanks John. I had indeed typed the code into the AfterUpdate box. Following your instructions, it now works.
However, another problem has arisen. When I select a Customer ID from a drop down list (I’ve changed the text box for a combo box) the Customer Details subform displays the appropriate record. This worked fine until a few moments ago when it ceased to function. Now, when I select a Customer ID, the Customer Details subform does not display a new record.
If you have the time, I would be grateful for any suggestions.

Rob

Hi John

I have done as you suggested but I get an error message stating that MsAccess cannot find the macro

I’ve made sure that my names are valid.

Help!

Rob

Thanks John for the response, but may I check something?
You said “In the after update event for the text box where you type the customerID put something like:”
Do you actually mean the CustomerID text box or do you mean the DriverID text box?

Rob

Thanks Steve. I’ll work through it when I have some time.

Rob