QBF Using Lookup Field?

[JPRENG]

Is there any way to use a lookup field as the control in a QBF as opposed to a text box?

 

[pr2-eugin]

Do not use Lookup fields..

 

[JPRENG]

What should i use? If the user is to enter the value theirselves they may get it wrong I want to ensure this doesnt happen

 

[RainLover]

I am unfamiliar with QBF. What does it mean.

Using Combo Boxes in Forms is fine. Just do not use them in tables. The problem in Tables and Queries is that Combos hide the real value that is stored.

 

[JPRENG]

Query by Form it stands for.

 

[pr2-eugin]

Thought QBF was a typo for QBE.. Well you can use ComboBoxes on Forms.. I think that is what you mean by Lookup fields..

 

[RainLover]

Your question appears to be answered.

That is unless you are having problems. If so post back with more information.

 

[RainLover]

Thought QBF was a typo for QBE.. Well you can use ComboBoxes on Forms.. I think that is what you mean by Lookup fields..

Paul

In that case what is QBE. I have never heard of that one either.

 

[pr2-eugin]

Paul

In that case what is QBE. I have never heard of that one either.

Rain remember the Query Builder grid where we drop in tables and select the fields we wish to see in the Result set? That is the QBE.. Think it has its own abbreviation Query By Example..

 

[RainLover]

Paul

Google did not give me a result with QBE, but it did with Query by Example.

Thanks for the clarification.

BTW I think the OP is going to come back with a hidden PK in the Combo. So he would be searching on the wrong thing.

I am going soon so I thought I might pass this onto you. But then I think you would have known that anyway.

 

[pr2-eugin]

Paul

Google did not give me a result with QBE, but it did with Query by Example.

Thanks for the clarification.

You are most welcome..

BTW I think the OP is going to come back with a hidden PK in the Combo. So he would be searching on the wrong thing.

I am going soon so I thought I might pass this onto you. But then I think you would have known that anyway.

I was thinking the same thing.. Thanks for the head up Rain. I am sure OP will have follow ups..