Can you post pictures?

-Raymond

You shouldn't need to "correct" it. You should be dealing with the data from the form, not from the table. There's no need to have dropdowns in your table at all. Is there something else you're wanting to do that I'm missing?

Chris Richard actually has a video Lookup Wizard that shows you how to correct having fields created with or like the lookup wizard.

First one is the report, second is the form, third is the table.Monica

Monica the dropdows are not in the table, they are in the form, and they work correctly, the data in the linked table is where the problem is. Ive attached photos.

You need to build a Query to base your Report off of.
Bring in your main Table and the related Tables. Concatenate FirstName and LastName from your Employee Table into a Calculated Field. This is what you will display in your Report instead of the ID.

Monica is correct the number is a reference and if you just wish to copy a value to a new table look at the column in the cobobox.

Combobox starts with column(0), so the name will reside in column(1).  is if you make a query if you pull all the fields down and take a look you will see  the id (reference) and the state name just need to look at your query and see what data you are trying to extract.  let me know if this help or i missed the ball on this one.

So the data that shows in the form, I need to show in the report and the table as well.  Sp if i build a query, it will accomplish this?

Chris Thanks for the clarification, I thought you had dropdowns in both. Which I used to do before I knew better, lol. Kevin is right, you need a query to pull these tables together. Link the ID fields from the table you used for the form to their respective ID fields in the other tables. Then you can drop the name (from the related table) into the query that you're going to base your report on. Hope that helps.

The query shouldn't affect the table correct? The data on the form is from the table, so how do I get that to match?

Monica The table row is set as a lookup wizard to pull data from another table, and the form has the dropdown from that row. The form shows the correct data, but the report and table show the row ID that is an autonumber.

I rebuilt the table, and it appears to be functioning as expected; the correct data is now displayed in the table and the report. Not sure what I did wrong in the first table.

Does anyone have any idea what I am doing wrong now in the above pic? I followed the tech help that was suggested; the data is from the same table. Only the city and state show the  ID #. City is the cit yid and state is the state id

Build a Query.

Chris

On your Form... the ComboBox is doing the work of converting the ID Field into the displayed text.

You can't put ComboBox's on a Form so you have to Build a Query linking the ID fields from your Table to the Relational Data to display the City, State, etc.

-Raymond

So build a Query for each one?

Hi Chris,

If you are looking to build a report that just displays the information that is shown in your table with the text that is displayed in the combo boxes, you should be able to create one query that pulls that information together. Your table would be the main contributor and then you would add the tables necessary to get the text values for the fields that are only showing id's.

Example:
Assuming the main table is PropretyT, you would bring in PropertyT.*
Then, whichever tables hold the other text values, bring them in. If Cities are in their own table, CityT, you would bring that table into the query joined on the CityID and then add CityT.CityName to your query.
Likewise, If states are another table, StateT, then bring StateT into the query joining the StateID from the main table to the state table and add StateT.StateName to your query.

Again, since we're not seeing your structure, I can't be more specific, just modify for your own table and field names.

I would also recommend aliasing your City/State names as well, City: CityT.CityName & State: StateT.StateName

We would need to see actual screen shots of your table designs to better be able to direct your more clearly.

Chris

Microsoft Access Beginner Level 2 Complete FULL Course. Form Design. Intro to Relationships

-Raymond

Donald I have a property form that I fill out with all property information, which is stored in the property table. The city and state fields in that form are dropdowns from a separate state table and a separate city table using cascading combo boxes.

I have a separate form that is sort of a property report, which has a property combobox that lists just the property name that is pulled from the property table as well. Then I fill the city, state, and other information in the corresponding text boxes using the VBA Code   "Me.textBox = [PropertyCombo].[Column](2). Text box is the name of the actual text box, and column (#) would be the column number of the data in want in the TextBox,

This works for everything except the city and state; it shows the city and state ID, but only for these 2 columns. But it shows the actual city and state name in the table. That is what is throwing me off.
I can post pictures if I know what pictures are needed, just the table design?

Yeah, would definitely need to see the table. Just so we can see exactly what you see, one shot with the table in datasheet view (normal), one shot each with it in design view city selected and state selected.

This way, we're working from the same info. I keep getting lost going through the thread above

Donald The attached screenshots are of my table.

The first table is the table from my form that I am having problems with, and the second table is the property table. The city and state show in the table, but when i use the VBA code,  "Me.textBox = [PropertyCombo].[Column](2). Text box is the name of the actual text box, and column (#) would be the column number of the data in want in the TextBox. I get the data in the first ones

Thank you to everyone who gave me advice on this issue. It appears that I was doing it all wrong. I changed all the text boxes to Combo boxes with the correct data from the tables, and it works. I was concerned that the combo boxes would show on the printed reports as well, just as they do on the forms. They do not. I'm not a fan of how it looks on the forms, but it looks fine on the reports.
Thank you again