Search results

Hello, I have a subform that has a junction table for its record source. The junction table has required fields, one of which is a field called Status. This is nothing unusual as all of my junction tables have required fields and I have never had a problem like this before. However, with this...

You should also be using the On_current if you want this to work when changing records. On_Load only works the very first time the form is loaded and the box will not be emptied when switching records

You need the Me. in front of your control name. I usually do this: Me.cboComboBoxName = Null

As Mihail stated, calculated fields should not be stored in tables. You should do this in a query and not try to save the data to a table.

Okay, glad you figured it out. BTW, I meant that the child field should not be the PK of your subform's table. Hope you got that anyway. If you solved the problem, you probably did.

I meant on the subform's ID field. This all sounds kind of complicated. Are you sure there isn't a simpler way to accomplish this??

You could put code in the AfterUpdate event of the main form's ID control that requeries the subform.

For some reason I cannot open your database. I am confused are you talking about a split form or a subform?? They are different. If you are using a split form you do not need to include a subform at all or link master/child fields. If it is a subform, why would the child field be ID?? It...

If the data type is date/time, that should work. Are there any other fields in the query with a sort on them? If so, make sure the date field comes first. It is easy to overlook that. Or if you checked that and it still isn't working you could try using an order by in your subform...

Not sure why that wouldn't work. You could try making a button on your form and see if it will output that way.

I solved this problem by: 1. creating a calculated field in my form for the Dlookup to the spouse's EntityID 2. Creating a filter query and using that instead of a WHERE statement

I want the continuous form to show both EntityIDs, so two records...

Hello I am trying to use this code to filter a continuous subform based on two criteria but getting a data type mismatch error. It works fine if I filter by just one or another. Perhaps it is not possible:confused: Or, does someone know a way? Dim intSpouseEntityID As Integer...

Okay, something actually did happen: it totaled up everything as you said. I think you need to take Paul's suggestion and try a DCount on the JobName field.

Maybe it is not possible to count on a header. I just tried and nothing happened.

Did you try doing a count on the Job group header the way I showed you?? That should give you the number of jobs as it will only count the JobName control.

Okay got it working. Sorry to have bothered. Took a lunch break and saw the light :) Here is the code for reference: Private Sub btnRemoveSpouse_Click() Dim PriorValue As Integer PriorValue = Me.Spouse.OldValue Dim dbs As dao.Database Set dbs = CurrentDb dbs.Execute _ "UPDATE tblContacts...

I think I see the problem. I need to change the SET part. Will post back if I still cannot get it working. Thanks!

Here is my code: Private Sub btnRemoveSpouse_Click() Dim PriorValue As Integer PriorValue = Me.Spouse.OldValue Dim dbs As dao.Database Set dbs = CurrentDb dbs.Execute _ "UPDATE tblContacts " & _ "SET Spouse = " & Me.ContactID & " " & _ "WHERE ContactID = " & PriorValue Me.Spouse =...

Yes, you can copy it into your group header section. Just follow the instructions and then do Ctrl+C on the count field and Ctrl+V into header and you will see.