Can I create a table from a form?

[Bradex]

I know I can create a form from a table using the form wizard. However, is the other way possible? That is, can I create a form first and then make a table from it?

I am asking this because, I think starting with the form first offers more designs for the 'controls' (each field in the form) to the user. once a 'field' is made in a table, the options for its display as a 'control' in the form is limited. For example, if i create a dropdown list in a 'field' in a table, I am not able to create a 'control' for it in the form like a radio button (Option group).

[pbaldy]

Can you? Sure, Google DAO TableDef. That said, I'm not sure why you'd want to. If you're letting users create tables, you probably have a design problem.

[Bradex]

The main reason is that I am not able to create a 'option group' for my field from the table.

[pbaldy]

I would think you could manually create an option group and set its control source to your field. It would need to be a numeric field if memory serves, as I think an option group will only return a number.

[Bradex]

Seems to be a good idea! I'll try! Thanks a lot!

[Bradex]

Even though I have set my field to be a number, it is not being shown in the list of fields shown by the options group wizard. Why is it so?

[pbaldy]

Not sure, but perhaps try leaving it unbound while building it with the wizard and set the control source after.

[Bradex]

Even in the property sheet (Data tab > Control source) that particular field is not being shown, only the ID appears.

[pbaldy]

Can you attach the db here? Perhaps it's because you used a lookup field, which I never do.

[Bradex]

Here it is...

[pbaldy]

Nothing shows because the form doesn't have a record source. Once I make the record source Table1, all 3 fields show up as options for the control source of the frame.

[Bradex]

Oh! Thanks a ton pbaldy!

[pbaldy]

Happy to help!