Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2005

Tip: Looking for answers? Try searching our database.

Modifying form after modifying Source table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Madhup Thakur - 30 May 2005 10:22 GMT
Access 2K Win98
I had based a form on 2 tables : ReferalTMH and EmpTbl with the following
record Source:

SELECT [ReferalTMH].[IDNUMB] AS ReferalTMH_IDNUMB, [ReferalTMH].[DepID],
[ReferalTMH].[Ref_Centre], [ReferalTMH].[Order_ref], [ReferalTMH].[E_D],
[ReferalTMH].[Emp_Status], [ReferalTMH].[PRI_rpt], [ReferalTMH].[Escort],
[ReferalTMH].[Ref_dt], [ReferalTMH].[Ref_Dr],
[ReferalTMH].[Ref_to],[ReferalTMH].[Transport], [ReferalTMH].[Brief_hist],
[ReferalTMH].[Ref_Num], [EmpTbl].[IDNUMB] AS EmpTbl_IDNUMB, [EmpTbl].[Name],
[EmpTbl].[PAYRoll], [EmpTbl].[Desig], [EmpTbl].[DEPT], [EmpTbl].[Blood_GP]
FROM EmpTbl INNER JOIN ReferalTMH ON
[EmpTbl].[IDNUMB]=[ReferalTMH].[IDNUMB];

I added a Text field "Sec_ref "in Table "ReferalTMH" and then added
[ReferalTMH].[Sec_ref] to the record source. I also Added an unbound text
box to the Form "ReferalTMH" and navigated to the Sec_ref  as Control
source. My problem is that the Cursor remains at the right most part in the
box and refuses any typed data( No errors msg box). Also on returning to the
record source in design view the braces of [ReferalTMH].[Sec_ref] are
stripped to read like [ReferalTMH].Sec_ref. What is going on? And what is
likely to get me going again. Or do I have to rebuild the form from a
scratch?

Thank to everyone who understands my problem.

Madhup Thakur
Philo Hamel - 30 May 2005 14:51 GMT
It should work... It might be best to try again.

-Open the properties window of your form;
-Instead of adding the [ReferalTMH].[Sec_ref] to the source by hand use the
[...] button next to the 'record source' textfield. This wil allow you to
drag and drop [Sec_ref] from the [ReferalTMH] table;
-Select the textfield that is supposed to be bound to [Sec_ref] and select
the right source using the dropdown list.

Hope this works...
Later,
Philo
Madhup Thakur - 31 May 2005 09:54 GMT
Thank you very much Philo,
It worked and saved me from rebuilding from a scratch. WIWIW
Cheers.
M. Thakur
> It should work... It might be best to try again.
>
[quoted text clipped - 8 lines]
> Later,
> Philo
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.