Recent content by DataBass

Thanks for the input. I am checking to see if converting will be viable. I'm not going to ask any of you to hold my hand and tell me how you do this, but I have some questions: 1. Do you have both 32 bit and 64 bit Office installed on your PC or do you have separate machines for doing...

I have built a database for a client which they have been using for quite some time. Recently they had some sort of issue which prompted them to uninstall and reinstall Office 365 on their machines. Unfortunately, they installed the 64 bit version and the database was built using the 32 bit...

That is a good idea. If I recall correctly, I think I tried that over the weekend. It did pull in the correct values for the Unit field, but having those joins made the recordsource not updateable and I couldn't create new records. I'll try it again this afternoon to doublecheck.

Did you actually use the word "parent" in the criteria? If so, did you put the DLookup in the control source? I could never get it to give me a result beyond the 1st record. If it behaves as you say, that definitely is a problem. Yes, the container and the subform have the same name. Good...

Sorry for the delay and thanks for the replies. I have tried all of your suggestions and I still get #Name? in all of the Unit fields. I don't get it. It seems like DLookup isn't capable of looking outside of the form it is on. I came up with a very "ghetto" workaround for the time being...

Sorry, I didn't see your question. Yes, the forms are linked with parent/child fields.

Maybe this will explain what it is doing better:

Update: If I use this: =DLookUp("Unit","tblData","Category='" & [cboCategory] & "' AND Stage='" & [Forms]![frmMain].[frmSub1].[Form].[cboStage] & "'") The first record in frmSub2 will get a result in the "Unit" field. All the other records are blank.

Thanks for your help. All of these are resulting in #Name? Man, this is frustrating. I use the 2nd reference you linked to regularly. It is excellent, however, as far as I know, the "me" & "parent" terminology only works in code, they won't work in a form property. If anyone knows how I can...

Colin, I just plugged that code in and all the unit fields are filled with #Name?. I have double checked to make sure I have entered everything correctly. Any idea why this might be?

I have a main form (frmMain). Inside frmMain is a subform (frmSub1) in Datasheet view. Inside that form is a form (frmSub2)in Continuous Forms view. It looks like this: On frmSub2 is a control called "Unit". I want it took look up the value in the "Unit" field in tblData where Category =...

The Doc Man, Thanks for the very thorough and thoughtful response. No offense taken whatsoever. I will take all the help I can get. You are 100% correct and in the end, I ended up splitting up the data and using queries as you and Colin suggested. I've been testing it most of the day...

Wow, thanks for all of the quick replies. It's amazing what some people can do in their sleep! Yes, it should be 6 The query idea works well. It's funny, if the 2 letters were at the end (19-001AA) it was much easier to work out. Thanks again

I would like to use the DMax function to find the maximum value in a field [YearNumber] in a table [tblData]. The values in the [YearNumber] field are formatted as follows: AA19-001 BB19-002 CC19-003 BB19-004 etc I would like the Dmax function to exclude the first 2 characters and only...

Thanks Isladogs and Cronk, that is very helpful. Your simplified examples make much more sense. I'm going to compare them to the original code and see if I can make sense of it.