At this point, I'll recommend that you post new questions to the respective
newsgroups. This way, more readers will have the opportunity to respond,
and you'll get more focused responses.

For example, questions about filling textbox controls based on a selection
in a combo box are common in the forms and formscoding newsgroups. You may
even find an answer there without having to post.

--
Regards

Jeff Boyce
Office/Access MVP

"ABZ123" wrote in message
oups.com...
Hi,

Thanks that worked like a treat. ))

I have 2 more Q.

1. I have created an Order Form and I can now select a Patient from the
Combo Box (PatientID). I have also created extra Text boxes for the
relevant field (Address, Tel etc). How do I populate these text boxes
from the Combo Selection.

2. In the Northwind DB, I looked at the way the Order form runs. It has
a way of selecting multiple items and adds it to list. How can I do
this on my DB to add prescription items? I want to be able to select a
product from a drop down menu and enter a re-order date. This info
should update the OrderDetails table with each product.

Many thanks.