Recent content by Brad108

Hi It still does the same, unfortunately. I forgot to say that the ContactID field on the form is being populated via another table via this code: Private Sub Form_Current() [Forms]![frmCompany]![ContactID] = [Forms]![frmCompany]![tblContacts subform].Form![ContactID] End Sub

Hi I have this code set up in order to close one form and open another form, at the correct record: Private Sub FirstName_DblClick(Cancel As Integer) Dim stlinkcriteria As String Dim stdocname As String stlinkcriteria = "[ContactID]=" & Me![ContactID] stdocname = "frmContacts" DoCmd.OpenForm...

Hi Thanks for the feedback. I originally started setting the database up as a conference listing database, but then decided that would be too complicated, which is why the tables are called events & attendees, but, aside from the names, everything else has worked towards a contact database...

Hi Mark Thanks so much for the sample database. I have now managed to match my table relationships and mother/child subform details to yours. It’s still not working though – I must be doing something so wrong. When I try and add an address via the company screen, it comes up with this error...

Hi Have tried some different settings, but they don't seem to have worked. Think its probably best to wait until you're able to give me some advice regarding the linking of subforms etc. Thanks again for all your help. Brad

Got those links set up ok, with all bits matching what you said. Looking good. Looking forward to 5 - to get the new child record to automatically figure out the PK they belong to by linking the subforms. This part sounds like it could solve my problems! All the best and thanks again. Hope...

Thanks for all the help Mark :)

Hi I am also getting this message when I try and add a record to the Contacts via the contacts subform on the Company page: "the changes made were not successful because they would creat duplicate values in the index, primary key or relationship. remove key etc." Does this help? Thanks so...

Hi Looking at the values of the ID fields - all are the same starting autonumber (although this could be just how I imported them) apart from AddressID in Company which has no values in it and is not set up as an autonumber field. This field should have the same value as AddressID in...

Hi Thanks for the reply - i have set up the connections as you said. With regards the the way the arrow on the line goes, I have set up the arrow going 'away' from the PK towards the FK - is that right? The relationship screen shows 4 table columns now. Addresses, with addressID (pk) going...

Hi I am in the process of finishing off a database and was wondering whether I could seek some assistance to problems which are driving me mad. I have has some very helpful responses from the forum and I am very grateful for them. I have 2 remaning problems and would be so appreciative of...

Please let me know if you need any more info on this. This should be an easy one, but I can't work it out. Just to clarify, what I want to do is: Open Contact form, choose contact. Click on contact company and then this opens the Company form, showing details of that particular company. At...

Sorry, meant to say its the 1st one I still have problems with (adding data to a form). Any ideas? :confused:

Hi When I change from my company screen to the contact screen, i have managed to get it to opne the contact form with the contact details from the previos screen. This is in my code to do this: stLinkCriteria = "[ContactID]=" & Me![ContactID] stDocName = "Contacts" DoCmd.OpenForm stDocName, ...

Hi Thanks so much for the help. Got the 1st one sorted out. The second one I have set to allow additions and data entry set to no, however when I try and type in it it comes up with a 'you can't assign a value to this object error'. Any ideas of whats going wrong here? Thanks Brad