Modifying form after modifying Source table

  • Thread starter Thread starter Madhup Thakur
  • Start date Start date
M

Madhup Thakur

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
 
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
 
Thank you very much Philo,
It worked and saved me from rebuilding from a scratch. WIWIW
Cheers.
M. Thakur
 
Back
Top