Querying a datasheet view

[eonelson]

Is it possible to do a query of the datasheet view of a subform? If so, how does one go about it.

Thanks.
eileen

 

[KeithG]

--------------------------------------------------------------------------------

Is it possible to do a query of the datasheet view of a subform?

I don't understand the question, can you please explain.

 

[RuralGuy]

For the record: Forms, DataSheet view or Single form, DO NOT contain data. They are only windows into tables or queries that DO contain data.

 

[eonelson]

Datasheet view

I am beginning to understand that part about the window and that if you don't have a table you won't have the data.

However in looking at both views of a form (i.e. the datasheet view and the table view) I am seeing that the data is being presented differently.

Problem: In my form I have a drop down box to allow the user to select a county. The drop down info comes from a lookup table that has two fields, a numerical designation and a county. When I look at my data in the datasheet view all records have the county listed by name. When I look at my data in the table view, the first half of the records have the counties by name, the second half of the records have the counties by number. I cannot figure out how to get that fixed and I need to query by county name.

This may be a backdoor way to do it, but I figured if I could query my datasheet view that would solve my immediate problem -- but it definitely doesn't fix the larger problem of solving the mixed data in my field.

Thanks for your insight.

eileen

 

[RuralGuy]

Is there any chance you are using lookup fields in your table?

 

[eonelson]

look up field

Yes, it is a look up table that the drop down box is connected to.

 

[RuralGuy]

You should eliminate the LookUp field and the solution to the issue will be easier to see.