Forms

[Leon Slutzkin]

I am teaching myself Access. I prefer to create forms to enter data instead
of tables. Where possible I want to use Option Boxes instead of having to
input data each time. Each option box in a group assigns a value which then
populates the table. How do I convert the value assigned by the option box
back to the name of the chosen input

[Allen Browne]

Re: Forms

Answers embedded.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leon Slutzkin" <slutzkin@kings ley.co.za> wrote in message
news:d148b2$f5g $1@ctb-nnrp2.saix.net. ..[color=blue]
>I am teaching myself Access. I prefer to create forms to enter data instead
> of tables.[/color]

That won't work. Forms cannot store data (other than in tables).
[color=blue]
> Where possible I want to use Option Boxes instead of having to
> input data each time. Each option box in a group assigns a value which
> then
> populates the table. How do I convert the value assigned by the option box
> back to the name of the chosen input[/color]

That is also going the wrong direction. Create a lookup table with two
fields:
- a number that is unique;
- the text value associated with that number.

Then in your main table, you can store the associated number for the value.
For an example of that, see the Shippers table in the Northwind sample
database, and how the Orders form interfaces that with an option group.

In general, though, this is a very poor interface. The whole thing has to be
redesigned if they ever add a new shipper.

[Leon Slutzkin]

Re: Forms

Thank you for the reply. I am familiar with the concept of the table but
you say that inputting via a form will not work. I thought that after
creating a table one can input data using the form with the data
populating the table. Is this incorrect?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

Re: Forms

That is correct.

After you have created the table, you can create a form that is bound to the
table, and enter data into the form so that Access saves it in the table.

What you cannot do is "create forms to enter data INSTEAD OF tables."
Apologies if I misunderstood you.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leon Slutzkin" <slutzkin@kings ley.co.za> wrote in message
news:42368b67$1 _2@127.0.0.1...[color=blue]
> Thank you for the reply. I am familiar with the concept of the table but
> you say that inputting via a form will not work. I thought that after
> creating a table one can input data using the form with the data
> populating the table. Is this incorrect?[/color]