Search results

Thank you dbGuy! Reading your latest reply finally clicked in my head. I was kind of thinking that's what you meant earlier. I just didn't think it would be that simple! I made a table containing the form names and added it to my combobox row source, joining the DataModeID and the FormID. The...

Thanks for responding for clarification. The combo does not have Barcode or Manual as the visible elements. The combo is actually 3 columns 1st column is bound and hidden (ID for a clinic) 2nd column is visible, shows the clinic name 3rd column is hidden and is the value for Barcode-1 or...

This sounds simple enough, but could you explain how I would get the Form Name, just create a field in my table with the form name in there? Then add it to the row source of the combobox? Or are you talking about using the Access (hidden) system tables that hold properties of all the database...

This sounds like a workable idea, one question though. How/Where do I specify the criteria to select the appropriate Case If the combo selection is 1 = Form A (Case 1) If combo selection is 2 = Form A (Case 1) If combo selection 3 = Form B (Case 2) and so on....

On an After Update Event of a combobox, how would I be able to open a specific form depending on the combobox selection. The Row source of my combobox is SELECT tblClinic.ClinicID, tblClinic.Clinic, tblClinic.FKDataModeID FROM tblClinic ORDER BY tblClinic.Clinic; Depending on the value of...

OK, thanks for the comments. I figured out what to do. Leaving my solution in case anyone in the future happens to find this post in a search. I had to dirty the record, I did that by a Lost Focus event of my combobox (after setting that combo to have the focus) Private Sub cboName_LostFocus()...

Hello, I have a strange situation which has me stumped. I have a main form with a subform and a combobox. Originally, when you selected an item in the combobox on the main form, the record would save (i.e. an Autonumber was generated). Then you could go about your data entry in the subform. But...

You're right. I didn't think about adding in a Requery. I added a requery and it works as it should! :)Thank you. If a name has already been entered, it stays the same. But when you go to a different record and the combo is blank, the user logged into the database is now the only name that shows...

Thank you DBguy, I tried your suggestion, but it didn't work as I was expecting. It still shows all the users in the combobox when that field is empty. Additionally, the query builder grid exhibits some strange behavior, it is splitting up the statement into two parts in the builder grid, even...

Hello, I have a combobox on a form that is a list of usernames. It works in it's present state. However, what I would like to do is to change the list of names if the combobox is Null (no user has been selected). In that case, I would like the list to select the current user that has the...

Also thank you to MajP and jdraw. MajP that looks as if it works, but beyond my ability of creating a public function, but I will give it a try. jdraw, I tried your way and it works too. Especially since it just shows the fields with the value I want rather than putting the value in another...

Thank you isladogs! I didn't know to use IIf and reverse the order of the functions them. I'm fairly inexperienced with functions.

Hello, I've tried searching for this problem in this forum, but no luck. In a field I have a text string (combination of alpha/numeric) What I'm trying to extract is the string if it occurs within the first 4 characters of the string. I probably need to use a combination of Left function and...

I didn't start this thread. Can I mark it solved?

I just wanted to repost a generic version of the database if it helps anyone. It's not really a "checklist" anymore (but you could add the Yes/No checkbox back in). It's more of a list with responses available for items in the list. As Mark pointed out some things, the record needed to be saved...

SOLVED...Thank you Mark! I was able to get the list to insert itself into the record. I added an after update event on a field in the form to save the parent record (DoCmd.RunCommand acCmdSaveRecord). Then my second after update event (which is the Requery of the subform) happened automatically...

Thanks Mark. That isn't something I even knew about. I guess I could figure out a way to save the parent record before calling the requery. Thanks for that insight!

Thanks for replying Uncle Gizmo. Is it possible for you to take a look at my database, with the changes I made and see if you can find anything wrong? It's in post 16 above. I deleted the checkbox from the original example and replaced it with a combo box of possible responses. Could that be...

Thanks for taking a look Mark. I wonder why if the "fCopyListToData" gets called the first time nothing happens, but the second time it adds the list. Do you have any idea as to how to fix the "fCopyListToData" problem? I have sent Uncle Gizmo a message to see if he can offer any help. He was...

Ok, I added a msgbox to the After Update code: Private Sub fldDatePerformed_AfterUpdate() Call fCopyListToDataOnlyOnce(Me.masterID) Me!subFrmWinData.Requery MsgBox "Date Entered", vbOKOnly End Sub I also changed the Requery line, because I was reading on "The...