DlookUp Question (1 Viewer)

[fenhow]

Hi I have a form that I want to put some data on. The data lives in a simple 2 column query. It has Type and Count
IE Human 3, Animal 5

How would I get this data and put it on a form? The form Is not related in any way to the query.

Thanks.
Fen

 

[pbaldy]

Options include a combo or list box, a subform, or DLookup(). I'd only use DLookup() for a single value.

 

[Galaxiom]

Firstly change the fieldnames. Type and Count are both reserved words.

Why not use form bound to the query? Otherwise it can be displayed in a listbox with the query as its RowSource.

It really depends on what you want to do with the data.

 

[fenhow]

Thanks subform was the best way to go. I really appreciate it.
Fen

 

[pbaldy]

No problem. Galaxiom is certainly right about the field names, if those are the actual names.