How to add fields to a table after a form has been created.

blogmad

Registered User.
Local time
Today, 17:20
Joined
Feb 24, 2006
Messages
16
Anybody able to help me with this. I think there should be a simple solution to it, but it eludes me at the moment. Basically, I have created a form in MsAccess with alot of vb script on it, but
now I realise that I have to add more fields to the source table.
If I insert a new unbound text box onto the form, how do i bind it to
the new field in the source table. is there a formula that I should
use? When I look at the dropdown in the control source property, it
only gives me the fields that were in existense at the time the form
was created?

your help appreciated

thanks
 
You need to make the changes to the table first, then open the form and the new fields should appear for selection in the control source property.
 
Ahh! I see the error of my ways. Source of Form wasn't a table, it was a query...
thanks for that:)
 
a form in MsAccess with alot of vb script on it
Are you sure you are writing VB Script and are not writing VBA? VB Script is an entirely different animal (still based on VB as is VBA) although you can actually use VB Script in Access procedures if you select the reference to the windows scripting library.
 

Users who are viewing this thread

Back
Top Bottom