add new field after using wizard Form

[Ankie]

Hi everyone,

I have made a form using the wizard, the form is based on some tables. Now I have to add one new table to the form, how can I do this? If I change the recordsource, it wouldn't work, I can't even write anything in the form.
Is it possible to add a new table or query to a form that is made with the wizard? Or have I to made the whole form again??

Thanks,

Ankie

 

[ColinEssex]

A form should be based on a query.

You can create the form using the wizard, then change it using the forms properties afterwards.
If you need to add another table, this will be added to the query. The new fields can then be added to the form manually.

I often use the wizard to create a form to save slogging through a manual creation - the wizard does the hard work, then fine tune it afterwards.

Col

 

[Ankie]

thanks!

But can I use more query's in one form? And can I add a query later to the form?

 

[Robert88]

Hi Ankie,

Yes you can use more than one query, I suppose it depends on how much information you have to display and how much screen space you have.

Robert88

 

[Ankie]

Thanks all!