Search results

Dear, I have a master form linked up with 3 subforms; what i want to do is ... when i move focus from main field "SNO" (Primary Key field), it finds the existing record and display and if no record found then clear all the form & subform and make new entry.... I tried to find solution from...

Ok bro... Leave combobox.... Suppose i have a text box "SNO"... After update value in SNo txt box, if records exist in main form and subform then show them , else keep all blank....

thanks dear... but i cant make combobox unbound because this is bound with SNo field of master form ( Master Table "Sales" with primary key in Field "SNo"), if i will make it unbound then how i will save record in Master Table.... 1. Master Table "Sales" Fields: SNo, CustomerID 2. Child Table...

Dear, What i need is very simple... sorry, if i am not able to elaborate my problem.... i will try again, I have a combobox "SNO" on Main form, when ever i will write any value here... if the record with that "SNo" exits, it will populate the mainform & subform accordingly else create the new...

Brother, i agree what u said.... but if works only when u do navigation in records. but if u enter any value in master field with existing record, it doesnot populate child records in subform.... this is my problem......

Dear Friends, I have a main form with subform, what i need is when i change value of main form and record exits then populate data for subform based on main form value else clear subform for new data entry.... Kindly guide, Main Form: FrmSales Main Form Field: SNo (Primary Key) Subform ...

Hello dear, I want to delete a post from my account but i m not getting any option.... Kindly guide... How can i delete a post???

Thanks dear

Its quite helpful bro... Thanks

yes, this is 11000 on FrmSales_detail and i want to show in GTotal at FrmPayment_Detail

bro, that was just example... basically, on each new entry in FrmSales_Detail, i need to update GTotal.......

Hello Friends, i have 02 subforms and i want to update Form2 on update value in Form1, 1. FrmSales_Detail ( Field: SubTotal) 2. FrmPayment_Detail (Field: GTotal) What i need is, when i enter data in subtotal, it will reflect to New Row in GTotal in FrmPayment_detail .... Kindly guide,

thanks all dear.....

Plz see the attached image for reference.... I need scrollbar width to be reduced... i need combobox dropdown menu to be shown only on focus, else hide it....

Yes bro u r right.... How it can be possible

I want to save some space to adjust the cells....

1. It means that there is no way to decrease the width of scrollbar.... 2.u didn't get mypoint about combobox.... I have a bound combobox but i need to look it as a textbox but when i click on it, it gives me dropdown option to select value.....

Hello Freinds, 1. I want to change scroll bar width in subform view.... plz tell me how can i do that? 2. Combobox dropdown, only show when i click on it else it shows as text box... how can i do that? regards,

thanks dear....

Hello Friends, I want to disable textbox edit in msaccess, i did it by using its property Locked= True but i want that even focus doesnot go to textbox like Labels.... my purpose is to make the textbox locked, visible and even can not be mouse clicked...... guide me plz....