Modifying and Existing Form

[2565]

I have an existing form. I want to add an extra field to the form to show me existing data held within a query. In this case "Customer ID"
to I use a text box or an bound object frame, and how do I link this back to the query in the properties box

 

[Fizzio]

This is difficult to answer without more information. If your form is based on a query in the record source, (Select the form in design mode and click on the top left grey square - view properties and click on the Data tab.), click the 3 dots and it will take you to the query design grid. From there, you can add any field from any table into your query and it will be available to your form.

Back on the form, either drag and drop the field you want from the field list onto the form where you want it (button on toolbar to enable) or use the textbox wizard (enable wand in toolbar and click the textbox control) and follow the instructions.

I apologise in advance if you are more proficient than this.

HTH

 

[2565]

Thanks, I didn't know how to check where the form was linked to (form propoerties), so learn't something there. I managed to link the field to Invoice ID using the drop down from the control source. So I've done it, I've always had to delete forms in the past and start from new to add fields, stupid I know, but if you don't know and have no one to ask........
On another point I've never got the text box wizard to work, and it's still a mystery. I've got the wand button in on the tool bar.
Thanks anyway

[This message has been edited by 2565 (edited 02-27-2002).]