Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

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)
{
}
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

Hello Rey,

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…