Form displays ID number, not data

[Twimm]

Hi - I'm a newbie here. I found this place while looking for a solution to a form issue I'm having and it looked like a good place to hang out.



I recently found an access calendar online that I can use in my database. It's just a subform repeated over and over so that it displays like a calendar. It seems to work great and is exactly what I need, which is to allow users to see the calendar of upcoming events and/or add events. I'm having trouble with one thing though. I changed the underlying source for the subform to a query using tblSchedule and tblPresenter, with those tables related via a PresenterID key. When the data displays, it displays the PresenterID number instead of the presenters name, even though the query is set to display the name. I'm sure this is an easy thing to fix, but I'm not sure how. I've posted the SQL statement bleow. Any thoughts would be appreciated.

SELECT tbl_Dates.EventDate, tbl_Dates.Location, tbl_Dates.StartTime, tblPresenter.Presenter
FROM tbl_Dates INNER JOIN tblPresenter ON tbl_Dates.Presenter = tblPresenter.PresenterID;

[TheShabz]

For step 1, run your SQL in a query and see if it returns the results you want. If not, there's something wrong with the SQL. If so, your subform needs fixing.

[Twimm]

It does return what I want. I figured it was the subform, but I'm not sure where the issue is. It looks okay, and aside from this, it runs great.

[TheShabz]

That's really weird that it would show something that isnt pulled in the query. can you post the db for us to look at?

[Twimm]

That's really weird that it would show something that isnt pulled in the query. can you post the db for us to look at?

Actually, there's no need now. I finally figured it out. There was a piece of code I hadn't looked at closely enough. Once I altered it a bit, it started working the way I had hoped. Thanks for the offer though...I'm sure I'll be back for more help in the not too distant future.

[TheShabz]

No problem. The best ending is when the one with the issue fixes it him/herself. Oh and go ahead and mark the thread as solved please. Take care.