Problem populating text box with query

[Lensmeister]

Hi,

As a newbie here I hope someone cane help me.

I have Acess 2003 and am making a database that holds records or football matches. I haven't created any relationships as yet. The main table is called tbl_Matches and the Primary key is an auto number. In this table I have the following fields I am using in a query (there are other fields in the table but not used in the query).

[Home] 
[HG] 
[Away]
[AG]

In the query I am using the table tbl_Matches I have a caluculation that says

IIF([HG]>[AG],[Home],[Away])

The only column that shows is the answer.

This is producing the correct answer I want.

I have a form (frm_Matches) that has all the fields for the tbl)Meatches on it. Now this is where I get some problems.

I want a textbox to show the result of the Query (qry_WinTeam) to appear in it.

I have tried a few things and am now stuck. Please help if you can.

[NeoPa]

Build the query (qry_WinTeam) to show all the values of the form, then bind the form to this query instead of the table. It will be display only.

Otherwise, have an unbound TextBox which simply uses the same formula to show [HG] or [AG] as selected.

[NeoPa]

It looks like you may be having problems designing the table structure in a sustainable way (you may find things it can't do for you later because the design has not been properly considered now). I suspect you will want details of what the results of the games were etc. The data needs to be stored at the lowest logical level. This way higher stuff can be deduced using queries etc.

I recommend you take a quick look through Normalisation and Table structures.

PS. Welcome to Bytes! (It seems you don't live a million miles from me :D)

[Lensmeister]

@NeoPa

I have added a textbox. I have added the

IIF([HG]>[AG],[Home],[Away]) 

What property of the Textbox do I add this to?

I did add it to one (default value) but as I moved from record to record it did not update.

Sorry for sound daft.

I live in Croydon .... :( Thanks for the welcome.

[NeoPa]

Try (in the Control Source property) :

=IIf([HG]>[AG],[Home],[Away])

[Lensmeister]

Ok got it now ....

Thanks a lot.

saw the Control Source property now.

Thanks again.

I may have some other daft questions soon enough. LOL

[NeoPa]

I look forward to seeing them.