Search results

Will have tinker later many thanks

Forgive me, I have have it in the table but does not appear with the drug when drug selected I'm assuming I need to link the fields somehow rather than using two separate combo boxes which sort of suggests the need to enter two values.

Yes certainly the medication selection is purley a record of what a patient is taking so that the clinician can handover to a hospital or recieving body to ensure there are no reactions The prupose is purley advice for the clinician entering data, for example if the patient was taking...

The prime is the medication name,,, the pupose needs to match the prime Purpose does not need to be selectable

Ok so could I ask would need a relationship or another link some how

Many thanks really strting to take shape and looks a lot better using that technique.. My medications table a part form ID and foreign key has two fields the drug name and its purpose.. I never want to select the purpose but do want it to show when I select a drug.. do I link this through a...

Yes that looks interesting certainly a more pleasurable way to enter data

I only used the combo box as it seemed to be the easiest way to have searchable data I had not really given thought to anything else

PTMEDS table Med_Name and Purpose

What about going back to text boxes

Ok will searh to see what I can find

The user can select several medications for one patient, The informtion should then update the PTMEDS table which is linked to the patient through the incident

Each time I try to link the list box to the table to update records the list box stops working

Yes that is the correct form, it populates the list box but does not up date the PTMEDS record

PT Meds so this takes its data from a table called medication, I did this because that table will update quite often.. The idea is that the list box then updates the patient record

Appologies DB attached forgive me is quite messy as its the first attempt.. the basic for is the overall view what im trying to do is update the patient medication list from the list in pt meds

Good afternoon I have been struggling a little with the list box being populated from combo selections. The below works well allowing me to select from a list of 50ish items then they subsequently add to the list box The lookup list is is in one table called medication, the lbdrugs list box...

Me.Med_Name.AddItem (Me.cbmedsearc.Column(1)) this gives invalid use of null error

THe text boxt is a look up a data table that contains about 150 different medications so my thought is to start typing in the text box when the medication it appears and can be added to a list of medications that a person is taking