Text Box or Label?

[techsponge]

Im not sure if this is the best way to do this or not?

Currently I have a form with a record sourcebased on a query from tblMasterGamesList that I would like to display the game names from.

I have 27 unbound text boxes in the details section of my form. What I would like to do is lookup the game name (TktDesc) from TblMasterGamesList where the following conditions are met:

InPlayDate = is not null
CloseDate = is null
Assigned = is null
TktPrice = .025

The problem I am facing is each of my text boxes diplays the same game name, instead of each individual game name.

The simple answer would be to only put a single bound text box in the details section and make the form continous, but I have a different graphic for each game with my text boxes on top of the images.

If this is possible ANY help would sure be great!

 

[fneily]

Maybe I'm reading this wrong. It seems you just want to show the game name with it's picture based on the AND conditions you've given. Place the conditions in your query. Then create a form off the query. All you need on the form is TktDesc and picture. Do a search in these forums on how to store images and display them in a form. You do not store the image in a table, by the way.

 

[techsponge]

I do indeed have the form built on the query, the problem is that each bound field (TktDesc) is showing the same game name.

I will try and explain:

The X's represent my graphics, and on top of each graphic is a transparent text box. I did what you suggested originaly. The problem is ever text box has the first game name in it "Gone Fishing" so I have the same game over and over.


Detail Section of form
_____________________________________________________
XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX
X X X X X X
XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX
_____________________________________________________

XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX
X X X X X X
XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX
_____________________________________________________

XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX
X X X X X X
XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX

End details section
_____________________________________________________


Thanks for the help

 

[ssatech]

This might give some ideas:
Why not add a field with an Ole Object to your Table(tblMasterGamesList)store it as a Bitmap Image

Create your query for the record source of your form with those conditions as Fneily suggested.

Make your form continous as you suggested

Use a combobox for your lookup and the Row Source:
SELECT DISTINCT TktDesc FROM tblMasterGamesList UNION SELECT "<All>" FROM tblMasterGamesList;

In the afterupdate event of this combo:

Private Sub Filter_for_TktDesc_AfterUpdate()
If Me![Filter for TktDesc] = "<All>" Then
DoCmd.ShowAllRecords
Else
DoCmd.ApplyFilter , "[TktDesc] = Forms![frmMasterGamesList]![Filter for TktDesc]"
End If
End Sub

 

[techsponge]

Thnaks to those that have responded. I may have worked out part of my issues by indeed using continuos forms.


Sort of a follow up question:

Is it possible to display multiple records on a single detail line? Since I am only pulling a small amount of information (Description) I have a lot of wasted space on my form.

This is what I the form currently looks like:

Value 1 <------------------dead space--------------------->
Value 2 <------------------dead space--------------------->
Value 3 <------------------dead space--------------------->
Value 4 <------------------dead space--------------------->


What I would like to develop:

Value 1 Value 2 Value 3 Value 4
Value 5 Value 6 Value 7 Value 8



Thanks again