Choice of fields for layout -- on the fly

[dutchbailey]

I'm building a database of real estate properties. I have fields such as: TITLE, SHORT DESCRIPTION, MAIN DESCRIPTION, DSCRPTN 2, DSCRPTN 3, PIC 1, PIC1 CAPTION, PIC2, PIC 2 CAPTION, PROPERTY TYPE, AGENT and so on.

The main output for this database is sell sheets. HERE'S MY QUESTION: I would like the user to have the ability to--once in a layout--choose which fields populate which areas. I'm thinking of a dropdown menu (suppressed printing) by each "field area" (sometimes it's a picture box, sometimes it would be a text box) so that the user can choose which fields populate that layout of that record, at that time.

Can this be done?

[Ugo DI LUCA]

Hi,

Yes it can be done by using GetField( )

[dutchbailey]

thanks. short answer to a long question. I'll try it.