UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Unbound Control On Parent Form, Access 2013    
 
   
waitingroomz
post Sep 19 2019, 08:59 AM
Post#1



Posts: 93
Joined: 29-October 18



I have an unbound form txtRec on a Parent form and when I click the child form, the record PKID is populated in the txtRec.

I am having difficulties getting the Parent to change along with the txtRec. I have a list of functions that should occur every time the number in the unbound control 'txtRec' changes or >0, but it is not firing.

Assistance?
Go to the top of the page
 
theDBguy
post Sep 19 2019, 10:26 AM
Post#2


Access Wiki and Forums Moderator
Posts: 76,407
Joined: 19-June 07
From: SunnySandyEggo


Hi. Can you post a sample copy of your db?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Sep 19 2019, 10:38 AM
Post#3


UA Admin
Posts: 35,891
Joined: 20-June 02
From: Newcastle, WA


Simply inserting a value into an unbound control won't fire any events on that control. You'll need to fire them from the same place where you set the value of the unbound control on the parent form.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
waitingroomz
post Sep 19 2019, 11:27 AM
Post#4



Posts: 93
Joined: 29-October 18



See attached.
Attached File(s)
Attached File  Example_dtd_19_Sep_19.zip ( 1.54MB )Number of downloads: 7
 
Go to the top of the page
 
mike60smart
post Sep 20 2019, 11:19 AM
Post#5


UtterAccess VIP
Posts: 13,419
Joined: 6-June 05
From: Dunbar,Scotland


Hi

I only looked at your tblPatients and nearly fell off my chair.

This table is not yet normalised and needs a lot of work.

tblPatient should only contain fields that describe the Patient.

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
waitingroomz
post Sep 20 2019, 12:55 PM
Post#6



Posts: 93
Joined: 29-October 18



I am unsure as to what you mean.

But I appreciate the suggestion and would love to understand more.
Go to the top of the page
 
mike60smart
post Sep 20 2019, 01:19 PM
Post#7


UtterAccess VIP
Posts: 13,419
Joined: 6-June 05
From: Dunbar,Scotland


Hi

OK tblPatients should probably only have the following fields:-

PatientID (I added Patient because the Autonumber field should have a specific name that Matches the table Name)
StatusID
ClosedOut
SocialSecurityNumber
Birthdate
FirstName
MiddleInitial
LastName
Suffix
StreetAddress
City
StateID
ZipPostalCode
MobileNumber
Gender
MaritalStatusID (I added ID to this field which indicates that it will be storing the PK MaritalStatusID from tbluMaritalStatus)
EthnicityID (I added ID to this field which indicates that it will be storing the PK EthnicityID from tbluEthnicities)
EmailAddress

All of the fields that you currently have as Lookups should be changed to Text Data Types.

All of the other fields that you currently have should be moved into related tables.


--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th October 2019 - 02:20 PM