Search results

Yes, that is not what I meant )

Made mistake in the last Else statement on my first post. Corrected to as it is on my correct test db. The code from my last post works on its own. I just want the FieldID to be tested for conditions I described and open frmMoreFields to a new blank record or to a new record with FieldName...

I seem to have uploaded the file without the change you suggested. with this line of code DoCmd.OpenForm "frmMoreFields", , , "[FieldID] = " & Me![FieldID], , acDialog Me.FieldID.SetFocus i wanted the other form to be opened to the existing record if I wanted to modify it.

Attached the file.

Changing it to Else gives me syntax error. Added text delimiters, now even if the value in the list it seems to execute the IF statement opening frmSomeFields as acFormAdd :confused:

Lets say I have 2 tables: 1. tblMoreFields with FieldID as PK and a FildsName 2. tblSomeFilds tblSomeFilds has the FieldID as FK on the frmSomeFields the FieldID is a combobox. If it type a "Macaroni Cheese" there and it is not in the list I click ta button and the code will take that "Macaroni...

Oh I c. That's why it gives me mismatch error when I chose existing value from the list and click the button pointing to this line of the code: DoCmd.OpenForm "frmMoreFields", , , "[FieldName] = " & FN, , acDialog

My bad, no error, if it is not in the list, it just says that not in the list offering to open the Form to add.

What I am trying to do: when I type a name in FieldID (combobox) and it is not in the there I click the button. As i still have the text I was typing in the combobox I want for the code to check if the FieldID is not empty and not equal to the value in FieldName in tblMoreFields which is string...

Thank you very much for finding time to modify the code to work with the Edit Form. It works as it should do after I added changes you suggested. There seems to be some problems with requery when I am checking the CustomerID field form value and opening the selected ID in the edit form or a...

Thank you for looking in to it. I found this link: https://www.tek-tips.com/viewthread.cfm?qid=1765353 where you and others worked on this code. Will your code from that thread address the issue I pointed?

I see theDBguy already posted a link with solution :)

I use query to concatenate fields from parent and child tables as in the image bellow:

As I mentioned on my previous post it works great, the only issue now is with List Items Edit Form which which I explained in this thread: https://www.access-programmers.co.uk/forums/showthread.php?t=308033 Any suggestions will be greatly appreciated.

Ok, pinpointed it to the FindAsYouType code by MajP from this thread: https://www.access-programmers.co.uk/forums/showthread.php?t=307894 that I use for the combobox. Will ask him to see if he can help me with this issue.

No, I just want it to appear on the list from the dropdown. I just tested it on the test DB I have and it works there. That means it has something to do with the form on my current DB :(

Following the steps, the value does show up on the list. Does it make any difference that I have a combobox/dropdown?

You are right:o Form. The property for the Data Entry is No at the moment, but it did the same for it set as a Data Entry Form as well.

It is List Items Edit List and the source is a query.

I am trying to utilize the built in function "List Items Edit List" that opens another form to Edit/Add new record. The problem is when i return to the main form it does not appear in the list of records of that combobox. Any suggestions how to solve this out?