Rayne
asked on
Table Column to Form- VBA
Hello
There is a table with 4 columns (lets say)
When i made a form initially, the table had 3 columns. so the form had 3 fields. Now how do i use vba to add the 4th new column to the form?
Thank you
There is a table with 4 columns (lets say)
When i made a form initially, the table had 3 columns. so the form had 3 fields. Now how do i use vba to add the 4th new column to the form?
Thank you
How are you displaying the table on the form?
ASKER
Hello Imnorie,
The form has to be in datasheet view always
The form has to be in datasheet view always
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open the form in design view, open the Field List and add the new field to the form.
Oops, think that's already been suggested.
Oops, think that's already been suggested.
ASKER
Hello Scott,
Yes totally agree, creating it in runtime is not logical. But I would want to have a button that i could press sometimes that does the form refresh and I think this serves that purpose
Thank you :)
Yes totally agree, creating it in runtime is not logical. But I would want to have a button that i could press sometimes that does the form refresh and I think this serves that purpose
Thank you :)