Creating New Tags To Form

[Rich_Lovina]

CREATING NEW TAGS TO FORM

As an Access convert from Lotus, I'm making progress, but here's my question:
I use many yes/no logical operators,based on query from 6 related tables.Each new search often requires a new yes/no. In Lotus I can go straight to field definition and add, then add new field straight to my form.
It would seem the only way to add new tags is to add them to the table used in the query, then add them to the query?
This seems to be a little tedious path?
What are there alternatives,as I'm up to 18 logical operators?

[This message has been edited by Rich_Lovina (edited 08-25-2001).]

 

[D-Fresh]

The only other way I can think of is to write VB Code and append the definition to your TableDef and QueryDef. If you write this once, all you'll have to do is run the function and input the fieldname, and it will create the new field for you. Hope this helps.

Doug

 

[Rich_Lovina]

Thanks yes this appears my conclusion also.