Rayne
asked on
access vba - table columns not in form
There is a table and a form on the top of that table. Now overtime, users add in more columns to the table. The form still shows the old columns but not the newly added column. Is there a vba to do this so that it takes in the form name and table name as arguments and returns a list of columns that are in the table but not in the form itself for example –
Function ShowNotinForm (myTblName,myFormName)
{
}
Function ShowNotinForm (myTblName,myFormName)
{
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I need it like this >> Grab all the table column names first and check if it’s in the form or not…..
What you did is >> grab all the form column names and see if it’s in the table or not…