Forms

[Guest]

I Have to make a data base that needs a form to generate a number for me when
i click on one number. For example if i make a combo box , then in the form i
click on one of the numbers in that combo box it will automatically generate
the corresponding number into another filed. Is this possible to do?

 

[Damon Heron]

The second number is random?
If not, then what is the source of the number? Is it calculated from the
selected number?
Are both numbers stored in a table?

More Info, please....

Damon

 

[John Vinson]

I Have to make a data base that needs a form to generate a number for me when
i click on one number. For example if i make a combo box , then in the form i
click on one of the numbers in that combo box it will automatically generate
the corresponding number into another filed. Is this possible to do?

It may be simpler than you think.

Base the Combo Box on the table containing the two number fields;
include both fields, and sort on the first one (the one you'll look
up).

Put a Textbox on the form with a control source

=comboboxname.Column(1)

to display the second (it's zero based) column of the combo when you
select the first.

John W. Vinson[MVP]

 

[Guest]

I have done that and thank you that has worked but when i fill that in on the
form it isn't going in on the table how do i get it to transfer that
information onto the table

 

[John Vinson]

I have done that and thank you that has worked but when i fill that in on the
form it isn't going in on the table how do i get it to transfer that
information onto the table

Storing it redundantly is a Bad Idea and is not necessary.

For a Report, you can create a Query joining your table to the table
with the two ID fields.

John W. Vinson[MVP]