Moving text in access

[benlawton]

Hi i have a form which allows the user to type in two bits of information in text boxes. At the moment they are named txtExhibition and txtDate. How do I make access take the data entered into these boxes and put it in a report?

I have a list of clients, and a query to search by county. I am aiming to produce a printable report which acts as an invitation. I want the user to be able to enter the county, the name of the exhibition and the date of the exhibition and produce an invitation. So far I have set it up to search by county, and putthe client's name and address on the report, but am having trouble.

[AIS4U]

benlawton:

Have you tried using the form/report wizard?

Have you thought about using the Mail-Merge feature of MS Word?

Or, perhaps you could create a form that would have three comboboxes so the user could select the coutry from one, the exhibition from one, and the date from the last one.

Then you could have a command button on the form which would say "Print Invitation" on it and when the user clicked on the command button an invitation would be printed out in Ms Word using the information they selected in the comboboxes, from your Access database.

I'm not an Access guru, but I think one of these world work for you.

Good Luck