Search results

Yes the info from my chosen LotID shows on the subform. I choose which LotID I want on the main form. When I open the main form (w/subform) there is a LotID displayed in my textbox so there are events displayed on the subform.

I created a qryLotID that has ADSID and LotID and I set my frmEvents (main form) recordsource to qryLotID and I get the same thing, when I open the form the first record is shown.

my recordsource points to a table. How do I tell it to wait until something is chosen?

I have a form with a subform on it. My subform gets populated by a lookup. On my main form I have an unbound (cboLotIDLU) lookup field and also a text box (LotID) that shows the chosen record. When I open the form my cboLotIDLU is blank but my LotID has an ID in it so the info for that ID is...

Nope I get a compile error Method or data member not found and the me.ADSID is highlighted

Can anyone help me through this? Rick

Thanks, I played with it last night but I just don't know enough about access to fugure out which of my stuff goes where in the inquiry. I create a LotID based on some info and stored in tblHarvest. tblHarvest's primary key is ADSID field. ADSID is the joining field in my tblEvents. so my entry...

In my DB I'm tracking seed. I have a form that I enter in some info in and an ID number is created (based on that info). Then in a different form I track "events" that happen to that ID (drying, moved, bagged). Is it possible to have a button or something like that that after my ID is created...

Thanks, Rural Guy that is awesome. Don't be surprised to see more posts from me on this DB I appreciate your time and effort!!! Rick

it's the frmEvents that the issue is on.

Correct. Here is the DB

This is in the After update event Set rs = Me.Recordset.Clone rs.FindFirst "[ADSID] = " & Str(Me![cboLots]) Me.Bookmark = rs.Bookmark

I tried that but from my understanding the RowSource changes and is entered based on my afterupdate event code. So when I changed the row source I got an message that popped up and then the code went back to the original I posted.

Here is the RowSource code for the nonworking section: SELECT LotID FROM tblHarvest WHERE [Product]=4 ORDER BY LotID; He is the RowSource from the working combobox: SELECT tblHarvest.ADSID, tblHarvest.LotID FROM tblHarvest; Rick

Rural Guy, I'm away from the database today, I'll get it potesed for you on Monday

OK I've been playing around and I did notice that my ADSID field is a numeric (autonumber) field but my LotID is a text field. I don't know if that means anything. I'm still confused why it will work just fine using just a straight LotID lookup with the cboLotIDLU, but using the exact same code...

After making that change I get Run-Time error '3464': Data type mismatch in criteria expression When I debug the line in blue is highlighted Private Sub cboLots_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone MsgBox "We'll look up ADSID = [" & Me.cboLots &...

Ok I'm with you on the bound column. No my bound column is the ADSID column and my returned value comes is the LOTID I added the code like you suggested and my cboLotIDlu still works fine and when I use the cascade or the cboLots I get the message it's looking it up but I don't get anything...

I was thinking it was unbound but if not then I'm assuming it's a string field because my LOTID is something like 02142005F18. As far as testing the findfirst comment I have no idea what you are saying most of my coding is done by cutting and pasting existing code and trying to make it work. I...

In my db I an tracking different types of seed and the process from harvesting the seed, through all the stages of drying and so on all the way to being bagged and sold. I'm not tracking the sale other than it was sold. On my Events Form I have a subform on it. On the form portion I have a combo...