Recent content by aweizd

Hi, I have a form with a subform. In the subform (based on a different form) I need a button to close the master form. In the subform I need to find out what the master form is so I can close it. Since I use the same subform in multiple forms I can't really hard code the name of the master...

Hi, Thanks for the tip! It actually works, although the conditional formating option are pretty slim, but I can live with that... I know I could do it with VBA as well and have more formatting possibilities, but I don't feel like getting into that now :) Thanks again Luke

(Referring to this post by ghudson) Hi, This post was very useful, it really helped me out, but I do have one question. My database will be used by multiple users and will be stored on a mapped network drive, just as the files that I want to link to. Now unfortunately not all machines are...

Hi, I have a (master) form in Single Form view. In this form I have a subform, which displays a list of other record that have the same GroupID as the record viewed in the master form. Obviously the list will also display the record viewed in the master form, so next to it i want to place...

I'm not sure this will work. In the version with your subform you could try Me.Refresh for the combo box OnChange event. This should also update the subform. The VBA code for this would look like this: Private Sub ComboBoxName_Change() Me!Refresh End Sub The On Change event in the properties...

Hi again, Just in case anybody would be interested I found the solution to my problem :cool: ! I didn't do a lot of testing but yet but it seems to work. This is what I did: I cleared the Link Child and Link Master fields and I set the subform to get data from a query. The query looks sort of...

Thanks for the fast reply... Well I guess that would be a way to do it, but if it's possible I'd rather have it all in one list. Thanks a lot for the suggestion. I'll keep looking for a solution, but if I don't find anything, then I guess radio buttons are the way to go. It does kinda seem like...

Hi, I tried searching for an answer, but with no luck. My problem is with linking master/child forms. What I want the subform to do is to show me a list of records that have the same "GroupID" as the master form. To do that I set the link properties to: Link Master Fields = "GroupID" Link...

Hi, I have a database with a form to view the record. In this form, besides the records data, I also want to show a list of other record which are related to the current record (they have the same GroupID). Now I was thinking of using a parameter query to find the records, but I don't know...

Hi, I am currently working on a database and I'm using a form to view the records. A standard Access behavior is to show an empty record (new record) as the last one. is there a way to disable this "feature". I would like my form to display only the records, which are really filled with data...

Thanx a lot! Luke

Hi, In a form I have 10 text boxes (TextBox1 - TextBox10), which are set to invisible. With a loop I want to change the "Visible" property of the first X text boxes. e.g. X = 5 Dim BoxName As String Dim i as Integer i = 1 Do Until i = X BoxName = "TextBox" & i i = i + 1...