Query to from problem

[Infinite]

Hello there, I have a created a form from a list box, but on of the rows is wrong. (see attached image) As you can see (Or not) the row "Status" just has 1s, 2s and 3s, they should be 1 for Current, 2 for not stocking and 3 for retired. I created a from directly from the query and it works fine, but when I create it using a list box, it doesnt show me what I want. What am I doing wrong? thanks!

I also noticed I have the same problem with Capture1 and Capture2. Capture 1 is should be (taken from the query) and Capture2 is the list box view.

 

[spikepl]

You need to stay away from lookup fields in tables. Go into your tables and change them all back to textbox.

If you want to see data also from lookup tables then you need to open the lookup table (or tables) in the query designer and drag the fields containing the text corresponding to the keys onto the design grid. You also need to relate the tables via the keys.

If all above is incomprehensible, then find and do an online access query tutorial and then come back.

 

[Infinite]

You need to stay away from lookup fields in tables. Go into your tables and change them all back to textbox.

What do you mean?

 

[Infinite]

If you want to see data also from lookup tables then you need to open the lookup table (or tables) in the query designer and drag the fields containing the text corresponding to the keys onto the design grid. You also need to relate the tables via the keys.

I am also not fully understanding that. Sorry, just a little confused and tired at the minute.

 

[RainLover]

Lookups should not be used in Tables. Get rid of all of them.

Lookups are good when used on a Form and nowhere else.

You could Google "The Evils of Lookups" if you need a full explanation.

 

[Infinite]

Ok, been while since I have not been busy. I have looked it up, but im not seeing why, nor how I could do what I want...And, If I changed them back to text boxes I would have to keep referencing back to it to make sure 1=A, 2=B, 3=C, etc, etc. How else could I do that? Wait, I think ive got, I should use the forms to edit the data, and view it, change it, and never use tables to edit it? correct? forms = Edit, table = ? and query = get info for form. Correct? And if im not, could you explain it? I've had explained it to me once, but I think I was confused..ish, thank!

 

[RainLover]

Go and look at a Database that has what you want.

Go to design view and look carefully at the Properties for the combo.

Especially Column widths and Number of columns.

You could also look at the attached demo.

 

[Infinite]

Ok, I think now after months of working on it, I THINK I know how to use a database. Tables for the info, querys to view, and forms to edit. I just finally got HOW to use those in the correct order. Only took about 3 months, 100 questions, and some smarts, Thanks for all your help!

 

[RainLover]

Ok, I think now after months of working on it, I THINK I know how to use a database. Tables for the info, querys to view, and forms to edit. I just finally got HOW to use those in the correct order. Only took about 3 months, 100 questions, and some smarts, Thanks for all your help!

Almost

Queries are for gathering information and sorting it plus other things.

The Form get it's data from the query and the Form is what you use for Viewing, Adding, Editing.

When you are finished the Database you make a special version that Locks the user out of Tables, Queries and Modules. They can only use Forms.

Did my attachment help.

 

[Infinite]

I little yes, I looked at it, was a little confused, but, after thinking about it, your database made compete sense. Thanks once again!

 

[RainLover]

Any questions please let me know.

Especially anything to do with the "Not on List" Function.