Search results

I worked it out. I just put the following code on the after update event from the combo box and in the on form load event. Me.txtPostCode = Me![cboTown].Column(2) Me.txtState = Me![cboTown].Column(3)

I have a combo box to select the town on the form frmCarers. I want a 2 text boxes below, txtstate and txtpostcode to be automatically updated when I select a town. I also need them to not disappear if I am to close and open the form.

I have changed all the relevant background settings but that bit won't change

On my form, frmCarers, if you scroll down to the Carer Notes at the bottom, why is the background of the first date white, where everywhere else is as it should be?

I have a combo box for selecting a town in the address and if the town isn't in the list, there is a button that opens a form to add a town. Once I add the town, I have a OK button that I want to requery the original combo box so that the new town appears in the list but I am not sure of the...

I see the record source is a query and I opened it and tried to make sense of the sql. I don't really know much about coding or sql so I didn't understand it. SELECT Students.StudentID, Grades.InstructorID, Grades.ItemID, Grades.Quarter, Grades.Grade, Grades.Notes FROM Students LEFT JOIN Grades...

I still don't see how I could apply what is in the example subform to what I want. All the record source says on the subform is StudentGrades, which is the name of the subform, so that has nothing to exactly study.

I can't see how that would allow multiple selection of items from a list.

I have a database made that has a form which shows the type of care that carers can provide. At the moment I have some checkboxes but I had it recommended to me that I should make it combo boxes so it allowed the addition of extra types of care but how would I do this? I thought I could have a...

I want to requery combo boxes on sub forms to a main form. I have the code in the on current event of my main form Private Sub Form_Current() Me.Form.Requery Me.frmCarerAvailabilitysubform.Requery Me.tblCarerNotesSubform.Requery Me.tblChildSubform2.Requery End Sub However, will this requery...

Thanks for that, I got it working :)

I tried using conditional formatting and all it seems to have done is that the boxes are now blue but they can still be selected, even when the checkbox is not selected. Maybe I just need to add an option to tblRelated of Not Related?

I solved my own problem, I just needed to remove the unused table from the tables row source in the list box.

My listbox is blank and I don't know why, must be something I am looking right over. The form is called frmLTCareNAvailable. Could someone take a look and let me know what I am looking straight over please? Thanks

Thanks for that. It slightly works. If I select a checkbox, the others get grayed out and you can only select that combo box , none of the others but if I have just all the check boxes unselected, it allows me to select them all.

I put in this code to the after update event: If Me.chkRelated = "True" Then Me.cboRelationship.Visible = True Else Me.cboRelationship.Visible = False End If With that, they all appear, even with one box selected then if I try and select one box, they all disappear...

Thanks, this seems to work. The only problem is that when you open the form, all the combo boxes are enabled, regardless of status.

Thanks for that Paul but I am a little unsure as to what I want. Here is my database I am developing. On my tblChild subform2, there is a checkbox to record whether children are related. I originally wanted to have to combo box enable when the checkbox is selected but do you have any suggestions...

I want to enable a combo box upon selection of a checkbox. It is stored in the form called tblChild subform2. The name of the combo box is cboRelationship and the check box is chkRelated. I am a novice at coding so I looked on the net for an answer and here is what I found and tried to adapt...

It's strange, sometimes it has shows that error message but sometimes it doesn't show it.