Recent content by Johnny

Okay got screenshots now I think it should show in order what happens and how the subform doesnt change to blank as it should after a new record is added from the combobox. I have to actually close the form and reopen it to get it to display correctly. For some reason jpeg one didnt work but...

Would you prefer the db itself? It's full of jsut sample data nothing important. It's 2007 but I can convert it to earlier if you like. If not I can get a series of screen shots sure. The form in question is frmDataEnter

I have a unbound combobox that takes all dates fronm a table equal to or greater then today and lists them, choosing a date populates a subform on my form. In the after update event of the combo I have: Private Sub cboDateEntry_AfterUpdate() On Error GoTo cboDateEntry_AfterUpdate_Err...

Based on the foundation code you gave me I was able to get this working thanks a lot!

That was it, thank you!

Ahh well I requeried the form and it works but if this is a smoother solution I will use it, thanks!

Thanks for posting that link I had the same problem which was solved through that link.

I have this running in the before update event of a field on a subform Private Sub idEmpTbl_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim iResponse As Integer ' specify the message to display strMsg = "Do you wish to save the changes?" & Chr(10) strMsg = strMsg & "Click Yes to...

Nevermind, found the macro conversion wizard.

I have a form/subform based on a query. To search records and add new items from a combobox I placed an unbound combobox there then used the notinlist event to add new items, works fine. But once the new item is added it doesnt refresh the form/subform. So I was going to requery the form in...

Well the easiest example I guess would be when I have a form based on a query that has two cascading subforms. For readability it has become best to have information from Table A to be in the subform from Table C essentially. But as you pointed out in the earlier post A--> B <---C I run into...

Dportas you have turned my Access worldview upside down, I was indeed thinking that relationships as in the access term and operation that "links" or joins tables through PK/FK. I now suspect my difficulty, which mostly lies with forms and specifically subforms, is a syntax problem with control...

Thanks you guys that does make more sense, especially thinking of the direction rather then 3 tables are linked.

Yes B is a junction table in my case, I'm just new at this and not sure the limit of 'indirectly" is as it applies to creating queries and forms. In my inexperienced head it would seem I could request data into C from A because it's linked to B, but sometimes it works, other times it doesn't...

Regarding 3 tables, A, B and C. If A is linked to B, and C is linked to B, does it mean A is linked to C and vice versa?