pls help im stuck (1 Viewer)

[cah1982]

Right im really stuck on this, how do you get the date visit to update correctly, it requeries but some times shows data it shouldnt. it should corispond with the subform.

next thing is the text box that says 'name needs to display the notes from that visit in , ( that thats in the sub form far right box.


any help on this would be much appreciated
in the dtabase its form "CD2"

 

[still_rookie]

get the date visit to update proorly

sorry but i didn't understand what you mean with 'proorly' ... is it a grammatical error ?

 

[cah1982]

its me carnt spell to save me life

 

[still_rookie]

i still don't get you mate...

 

[cah1982]

right date visit , time visit listbox , duration listbox, visit id listbox are all in a table. same details as the sub form a requery is done when Customer ID changes , but some times the date visit list box doesnt update proporly.

All the dta in them list box`s should show the same as whats in the visits sub form.

The text box that shows #Name? just above the visits subform should show the notes that are in the table visits (in that subform far right coloum)

So from that jpg it should display Went Okk in the #Name? text box

 

[still_rookie]

The text box that shows #Name? just above the visits subform should show the notes that are in the table

are you sure you have the record source set to the field you want the text box to display the informatio you want ?

What you can do is check on the tool bar above is the 'Field list' button is enabled. If it is, just drag the field you want from it.

If it isnt, then open form properties and put the record source to the table you want, and then drag the field from the Field list.

Or it just must be that ure text box is too small to display the information

Let me know if any of those worked

 

[cah1982]

no sorry i think its because the notes are in a different table

i have 2 tables

Customers
[Customer ID]
[Customer Name]

Visits
[Customer ID]
[Visit ID]
[Date Visit]
[Time Visit]
[Duration]
[Notes]

the realations are
Customers
[Customer ID]
1
to
many
Visits
[Customer ID]

 

[still_rookie]

so you got a solution?

 

[cah1982]

noop , i really need a solution to this its the only part that im really stuck on

could u try downloading the db file and having a look for me pls

 

[still_rookie]

sure... ill see what i can do..

 

[cah1982]

really alls it needs to do is look at the listbox at visit id and look it up in the table and display it in a text box , and to refresh when the list box changes


thanks still_rookie