Textbox to subform

[DodgyDavo]

Hi,

I have a form with 2 subforms. One subform has the field survery_monitoring. Is it possible to create a textbox where you can type information into the text box and have it display in the relevant field.

For example the subform is has different telephone numbers and each number requires its own survery monitoring. These comments can be quite long and i thought a textbox would be best to edit and read on the main form. Is there a way to do it?

I tried =[Lines subform].[Form]![Survey_Monitoring] but it will not let me edit it because it is bound to survey_monitoring. It displays information if i type it directly into the subform but not vice versa.

Thanx

DD

 

[TheAceMan1]

How are ya DodgyDavo . . . . .

This is a bit confusing, but from the example you give, why don't you just change the data type for your survery_monitoring field to Memo! With Memo fields you type up to 65K text.

TheAceMan

 

[hneal98]

Whether you can edit the data depends on how your data source is set up. You can not break the rules of referential integrety. You need to go back and see how the data your forms are based on all relate to each other.

 

[DodgyDavo]

OK ill try to explain more,

I have 3 tables in my database

BILLS LINES
Bill_ID (PK) Line_ID (PK)
Line_ID (FK) Lines/Equip_Order_ID (FK)
Initial_Bill_Details Line_Number
Date_Of_Bill Line_Type
Connection_Charges Line_Type
Rental_Charges Site_Location
Call Charges Survey_Monitoring

ORDERS
Lines/Equip_Order_ID (PK)
Lines/Equip_Order_Date
Poles
Connection_Date
Disconnected

I have 1 form and 2 subforms

frmorders
Lines Subform
Bills Subform

On frmorders i have the 2 subforms linked and working fine.

Instead of typing the details directly into the SURVEY_MONITORING in the LINES SUBFORM, ID like to enter the information into a textbox on the main form so that it displays in the LINES subform. Im not sure if i can attach the dbase to here....

DD

 

[hneal98]

I am not sure what you mean by "Im not sure if i can attach the dbase to here....". But you can put your text box on your main form, have the user type in data and then based on the after update event, have the data in your subform change to match what was entered as long as something is there in your database that cooincides with what was typed. Is that what you are looking for?

 

[DodgyDavo]

ive tried things along those lines and it just says 'control cant be edited; its bound to the expression [Lines subform].Form!Survey_Monitoring'

I meant can i attach my databse to show you what i mean?

DD

 

[hneal98]

Oh, no, I don't think you can attach your database. I would have you email it to me, but I am not at home now. Maybe someone else can have you email it to them.

It sounds like you are having difficulty understanding how the referential integrity works. You might want to go back an read in HELP about it and see if that helps.

 

[DodgyDavo]

OK hneal, thanks )

Just been a while since i used access and i remember doing something similar. Its OK though ill get round it somehow.

Thanks for your help

DD

 

[hneal98]

If you can wait another day, you can email it to me at hneal_98@yahoo.com and I can look at it then. That is my home email.