Modifying form after modifying Source table

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
 
P

Philo Hamel via AccessMonster.com

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
 
M

Madhup Thakur

Thank you very much Philo,
It worked and saved me from rebuilding from a scratch. WIWIW
Cheers.
M. Thakur
 
Top