Create a field lookup with value that I specify, in a form that I TYPE in. (1 Viewer)

[johnseito]

Hi,

I wanted to create a field lookup with values that I specify, not on the table sheet, but on the form. User can click on a text box or combo box and can select a list of value that I specify, not values that are listed on a table but ones that I type in, in the form.

Can this be done, and if so, could you please provide some guidance.

Thanks

 

[Galaxiom]

Combo Properties
RowSource: Values separated by semicolons
RowSourceType: Value List

 

[johnseito]

Combo Properties
RowSource: Values separated by semicolons
RowSourceType: Value List

Ok, I did what you told me and this is the list I put in the row source

;1;2;3;4;5

the selection on the form only shows 1,3, and 5.

Why is that?

 

[Galaxiom]

No semicolon before the first entry.

The ColumnCunt is set to 2. It needs to be 1.

Clear out the ColumnWidth which is causing one of the columns to have zero width.

 

[johnseito]

Ok, thank you!

 

[johnseito]

Hi,

Back to this, I tried to select some of the items I type in and then have these items inputted back into the Bid Table, but when I select the table to input, I can't select the values I typed.

If I didn't select the table to input I could select the values I typed.

Do you know what is wrong?

Thanks!!!!

 

[johnseito]

I thought I saw someone reply to my inquery
in my email but when I look at the site, I didn't see
the reply.

The reply is a replicate of my question, why would
someone do that.

 

[johnseito]

Attached is the response image.

 

[WSanchez]

Hi,

Back to this, I tried to select some of the items I type in and then have these items inputted back into the Bid Table, but when I select the table to input, I can't select the values I typed.

If I didn't select the table to input I could select the values I typed.

Do you know what is wrong?

Thanks!!!!

I am somewhat confused by your question, so I apologize if I don't address it.

If you want the values you select in your combo box to be entered into a table, you just have to change the Control Source of the combo box to the field in the Bid table.

 

[johnseito]

I am somewhat confused by your question, so I apologize if I don't address it.

If you want the values you select in your combo box to be entered into a table, you just have to change the Control Source of the combo box to the field in the Bid table.

I did that, but then the values to select from the combo box is gone, I can't select it anymore. When I don't put any value in the control source, I could select the values in the combo box.

Why is that and what is wrong? Thx

 

[johnseito]

I thought I saw someone reply to my inquery
in my email but when I look at the site, I didn't see
the reply.

Paul what are you trying to say?

 

[johnseito]

It looks like we have some people on here playing games, aren't we all
mature grown up or are we still little kids? Speaking to Paul and
people like him who aren't very serious with the issues the form is trying to
address.